I’m trying to use Power Automate Desktop to do the following:
Open Excel file
Click on Data>Refresh All
Save and Close
Below is an image of the Flow that I’m using In the Close Excel step, if an error is encountered because the Refresh All is still busy, then go to the ErrorHandler and Wait 30 seconds and try again.
The above works fine, but it only works if the Excel instance is visible. Please provide me with an alternative to achieve the above with Excel instance not visible.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Share
Report
All responses (
Answers (
522
