Forum Discussion
Refresh External data at regular intervals in the browser
In the following support page, I have noticed that we can refresh external data at regular intervals. How to do that? I have not found an option to choose the intervals.
3 Replies
That means refresh every N minutes (assuming the file is opened). Here https://support.office.com/en-us/article/refresh-connected-imported-data-e76a38b0-e2e1-400b-9f2f-c87b9b18c092 it is explained in more clear form
- Is there a way we the excel can refresh automatically on a specific day?
I guess that's only with third party tool or powershell. Idea is the same - open Excel file in background, wait for a while and save it back, assuming within the Excel file Refresh on Open is activated.
Another way to refresh, let say once per day, you publish the file on Share[point with Excel Services available or on OneDrive for Business refreshing dataset with Power BI services.
However, afraid I won't be able to give step by step instructions for any of above, practically don't use.
