Refresh an OLE DB data connection

If your Excel workbook has a connection to a table or query in an OLE DB data source, you can make sure it shows the most up to date information. Use the Refresh command (on the Data tab) to do this.

Need to connect to your OLE DB data first?

  1. On your worksheet, click any cell that contains your OLE DB data.

  2. On the Data tab, in the Connections group, click the arrow next to Refresh All, and then click Refresh.

Refresh Data Connection

To control how or how often the connection is refreshed:

  1. Click any cell that contains your OLE DB data.

  2. In the Connections group, click the arrow next to Refresh All, and click Connection Properties.

For very large data sets, consider running a background refresh. This returns control of Excel to you instead of making you wait several minutes or more for the refresh to finish.

Connection Properties

  1. On the Usage tab, set any options you want to change.

Check or cancel 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 or cancel a refresh, 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 Access data connection

Refresh a data connection to another workbook

Refresh an external data connection

Top of Page

Expand your Office 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.