Forum Discussion
Refresh External data at regular intervals in the browser
In the following https://support.office.com/en-us/article/refresh-external-data-in-a-workbook-in-the-browser-3e51741e-a9bf-4577-8342-7c07ae23dbbd, I have noticed that we can refresh external data at ...
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.