I am using UiPath to refresh the tables in an Excel without Excel Macro. I have tried using send hotkey Alt+F5 to refresh each table in a specific sequence. My problem is I cannot figure out how to wait effectively for the refresh to complete before going to next table.
I cannot use Excel macro, these are not pivot tables and it is not a good solution for me to put ridiculous time delay. Any expert can advise?