Troubleshoot Slow Excel Power Query Refreshes from Access
Question details
The user needs to identify why Excel Power Query takes more than five minutes to refresh data from an Access database.

- Product
- Microsoft Excel Power Query and Microsoft Access
- Device & OS
- not provided
- Scenario
- Refreshing an Excel Power Query connection that imports data from an Access database.
- Observed behavior
- The refresh takes more than five minutes. The source database, query complexity, Office configuration, or database damage may be contributing to the delay.
Identify the Access file used by the slow query and record its refresh time. Have a small Access table and, if available, a second database ready so you can compare refresh behavior.
Compare a simple Access table with the slow query
Start here to determine whether the delay affects one query, one database, or multiple Access connections.
In Access, open the affected database and select Create > Table. Add a few rows of simple data and save the table with a recognizable test name.
Open a blank Excel workbook and select Data > Get Data > From Database > From Microsoft Access Database. Choose the affected database, select the test table in Navigator, and click Load.
In Excel, open Data > Queries & Connections, right-click the test query, and select Refresh. Record how long it takes and compare that time with the original query.
Repeat the import and refresh with a small table in a different Access database. If only the original query is slow, open it through Data > Queries & Connections > Edit and review its Applied Steps, especially merges, grouping, and custom calculations.

Update Office and repair the affected Access database
Use these checks when the delay persists, particularly when several queries against the same database are slow.
Run Office Online Repair and collect support details
Use this option if updates and database checks do not resolve the delay, especially when multiple Access connections are affected.
Use WPS Spreadsheet to work with exported Access data
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel files, making migration straightforward for everyday spreadsheet work. Export Access results to an Excel file and open them in WPS Spreadsheet for review and analysis. WPS does not repair Microsoft Office or replace the Excel Power Query Access refresh workflow.

Frequently Asked Questions
Does a refresh taking more than five minutes mean my Access database is damaged?
No. Query complexity, data volume, connection conditions, and Office configuration can also cause delays. Import a small table through Excel's Data > Get Data > From Database > From Microsoft Access Database and compare its refresh time before assuming database damage.
What should I check if the simple table refreshes quickly?
Open the original query through Data > Queries & Connections, right-click it, and select Edit. Review Applied Steps for expensive operations such as merges, grouping, and custom calculations, and compare the amount of data with the small test table.
What if every Access database refreshes slowly?
Update Office through File > Account > Update Options > Update Now, restart the computer, and test again. If the problem persists on Windows, consider Office Online Repair and provide support with your Office build and comparison results.
Can I compact an Access database while other people are using it?
Compact and Repair requires exclusive access. Ask other users to close the database, close Excel connections to it, and make a copy of the file before selecting Database Tools > Compact and Repair Database in Access.
Can WPS Office fix my Excel Power Query refresh?
No. WPS Office does not repair Excel's Power Query engine or its Access connection. For work that does not require live refreshes, export the Access results to an Excel file and use WPS Spreadsheet's Open command to review and edit that data.




