Auto Refreshing Excel Sheet

Auto Refreshing Excel Sheet. I need to refresh data weekly into 6 templates. Copy the url you see and paste that into the excel web query wizard and click go;

MS Excel 2003 Automatically refresh pivot table when data from

Once i've amended it, i then want to email it to some recipients. When you manually refresh, or schedule refresh, on the dataset, power bi connects directly to the external data sources to query for updated data it then loads into the dataset. You can use the excel as external data source, you can set refresh the excel per 1 minute.