Microsoft Office Tutorials and References
In Depth Information
Refresh Imported Data
External data often changes; you can ensure
that you are working with the most up-to-date
version of the information by refreshing the
Refreshing the imported data means retrieving
the most current version of the source data.
This is a straightforward operation most of the
time. However, it is possible to construct a
query that accesses confidential information or
destroys some or all of the external data.
Therefore, when you refresh imported data,
Excel always lets you know the potential risks
and asks if you are sure the query is safe.
Remember, as well, that most external data
resides on servers or in remote network
locations. Therefore, the refresh may take some
time, depending on the amount of data, the
load on the server, and the amount of traffic
on the network.
Refresh Non-Text Data
1 Click any cell inside the
2 Click the Data tab.
3 Click Refresh All.
4 Click Refresh.
Note: You can also refresh the
current data by pressing Alt+F5.
To refresh all the
imported data in the
current workbook, you
can click Refresh All, or
Excel refreshes the