Refresh an Access data connection

If your Excel workbook has a connection to a table or query in an Access database, 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 Access database first?

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

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

To control how or how often the connection is refreshed:

1. Click any cell that contains your Access 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.

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

Check the status of 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 the refresh, or to cancel it, do one or more 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 data connected to a SQL Server database

Refresh OLE DB data

Refresh data connected to another workbook

Refresh data connected to an external source

Top of Page