Data Import & Export

Fix an Excel Connection to an Access Query That Will Not Refresh

Emma BrownEmma Brown Nov 20, 2026 870 views

Question details

Identify why an Excel connection to an Access query hangs during refresh.

Fix an Excel Connection to an Access Query That Will Not Refresh
Product
Microsoft Excel and Microsoft Access
Device & OS
not provided
Scenario
An Excel workbook connects to an Access query that combines SharePoint data with an ODBC data source.
Observed behavior
The query runs quickly in Access, but refreshing its connection in Excel may hang.
Before you start

Confirm that the query runs in Access and identify the SharePoint list and ODBC source it uses. Note the steps originally used to connect Excel to the query.

Solution 1Recommended

Isolate the SharePoint or ODBC source causing the refresh to hang

Use controlled tests to determine whether the issue follows a particular data source or the Excel connection.

1
Inspect the query

Open the database in Access, select the query in the Navigation Pane, and open it in Design View to identify the SharePoint and ODBC tables and how they are joined.

2
Test another SharePoint list

In Access, create a separate test query using another comparable SharePoint list with the same ODBC source. Connect a test workbook to that query and try refreshing it in Excel.

3
Test another ODBC source

Create a separate test query using a comparable ODBC source with the original SharePoint list. Connect a test workbook to it and try refreshing in Excel.

4
Compare the results

In Excel, use Data > Refresh All for each test connection. Record which combinations refresh and which hang, along with any error messages.

Isolate the SharePoint or ODBC source causing the refresh to hang
Interpret the tests: A query running quickly in Access does not by itself identify why Excel hangs. The comparison helps narrow the affected source or connection path, but may not identify the final cause.
Free Microsoft Office alternative

Work with Excel Files in WPS Spreadsheet

WPS Office is a free, lightweight Office alternative with a familiar interface and support for Microsoft Office formats, making it easy to move everyday spreadsheet work. It does not repair an Excel connection to an Access query.

Open and edit Excel workbooks in WPS SpreadsheetCompatible with Microsoft Excel XLS and XLSX formatsFamiliar spreadsheet interface for an easier transitionFree and lightweight for everyday office tasks
microsoft office alternative - wps office

Frequently Asked Questions

Why does the query run in Access but hang in Excel?

A successful run in Access does not rule out a problem in Excel's connection or its interaction with the data sources. Test comparable SharePoint and ODBC sources separately and record which Excel refreshes hang.

Where can I find my Office version?

In Excel or Access, open File > Account and look under Product Information. Record the exact version when asking for help.

How can I see how the Access query combines its data?

In Access, select the query in the Navigation Pane and open it in Design View. Review the source tables and joins, and mask sensitive details in any screenshots you share.

What should I include when requesting support?

Provide the Office version, the exact steps used to connect Excel to Access, the query structure, recent changes, and results from tests with another SharePoint list or ODBC connection. Remove personal information from screenshots.

Can WPS Office fix the Excel-to-Access refresh?

No. WPS Office is an alternative for working with compatible spreadsheet files, but it does not repair the Microsoft Excel connection to an Access query.