Refresh External data at regular intervals in the browser

[Anwesh Gangula]

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.

[#2]

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-c87... it is explained in more clear form

[#3]

Is there a way we the excel can refresh automatically on a specific day?

[#4]

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.