Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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).

Image Added

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:

...