Refresh data connected to another workbook

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.

Need to connect to another workbook first?

Refresh

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

    Refresh Data Connection

Control how or when the connection is refreshed

  1. Click any cell that contains your connected data.

  2. On the Data tab, click the arrow next to Refresh All, and click Connection Properties.

    Connection Properties

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

Refresh other data sources

Refresh a SQL Server data connection

Refresh an OLE DB data connection

Refresh an Access data connection

Refresh an external data connection

Top of Page

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Power Query is known as Get & Transform in Excel 2016

Import data from external data sources

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×