If your Excel workbook has a connection to data in another workbook, you can make sure it gets updated. Use the Refresh command on the Data tab to do this.
On the Data tab, click Refresh All.
If you have multiple connections, and you only want to update a certain one, select any cell within that data range, click the arrow next to Refresh All, and click Refresh.
Control how or when the connection is refreshed
Click any cell that contains your connected data.
On the Data tab, click the arrow next to Refresh All, and click Connection Properties.
On the Usage tab, set any options you want to change.
For very large data sets, consider checking the Enable background refresh option. This returns control of Excel to you, instead of making you wait for the refresh to finish.
Cancel or check the status of a refresh
If your workbook is connected to a large data source, refreshing it might take a little longer than you expect. To check on the refresh, or to cancel it, do one of the following:
Check the status of a query A message appears on the Excel status bar to indicate that the query is running. Double-click the message to check the status of the query.
Stop a background refresh To stop a query that's running in the background, double-click the query status message on the status bar to display the External Data Refresh Status dialog box, and then click Stop Refresh.
Stop a query To stop a query from running when background refresh is turned off, press the Esc key.