Popular Help Content
If Excel hangs during the refresh, disable Enable Background Refresh on all data connections. This is a known problem for spreadsheets with multiple web-based data connections. Find it under Data -> Connections -> Select Connection, click Properties -> unselect Enable Background Refresh.
NOTE: The data needs to be pulled/downloaded every 35 days (see warning label below) to maintain an active data connection/link. Otherwise, the data connection will expire and Step 3 needs to be repeated to re-establish a data connection. This can be achieved by clicking on Refresh All in the Excel dashboard (see instructions above).
Step 11: Send to Others
If you just send the Excel file to others they will be prompted to enter login credentials in order to refresh the data. If you don't want this to happen, you can do the following: