Fix an Excel Connection to an Access Query That Will Not Refresh
Question details
Identify why an Excel connection to an Access query hangs during 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.
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.
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.
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.
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.
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.
In Excel, use Data > Refresh All for each test connection. Record which combinations refresh and which hang, along with any error messages.

Collect connection and version details for further troubleshooting
Use this approach if the refresh still hangs or the source tests do not identify the cause.
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.

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.




