Hi everyone, could someone help me automate the refreshing (clicking the refresh button) of multiple Excel files (regardless of the number of files) in a SharePoint Site folder? This should happen weekly on Wednesday at 6 a.m. How can I achieve this? I would prefer to use Power Automate Cloud.
I don't see a step called "Refresh" in the Excel Online for Business section.
I simply need the automation flow to trigger the refresh button.
Thank you in advance👍
Quick question: Do you think Power automate is the Best way to do this?
With VBA code or even in the options you can make sure that the Data gets refreshed automatically when the file is oppened.
Was this reply helpful?YesNo
Under review
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.
58
Share
Report
All responses (
Answers (
