'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel Crashes When Saving After Refreshing Queries and Pivot Tables
Question details
The user is experiencing application crashes in Microsoft Excel when attempting to save a workbook immediately after running a "Refresh All" on data models, queries, and pivot tables.
- Product
- Microsoft Excel (Microsoft 365)
- Device & OS
- not provided
- Scenario
- Manually saving a complex Excel workbook containing external connections and data models after a data refresh completes.
- Observed behavior
- The Excel desktop application closes unexpectedly or crashes during the saving process following the completion of a data refresh.
Verify your current Microsoft 365 build number by navigating to File > Account, and install any pending Office updates before proceeding with troubleshooting.
Test in Excel Safe Mode and Disable Add-ins
Running Excel in Safe Mode helps identify if background third-party add-ins are interfering with the saving process after a data refresh.
Add-ins can sometimes conflict with Excel's memory management when processing complex pivot tables and data queries. Safe mode bypasses these add-ins.
Press the Windows key + R to open the Run dialog box, type 'excel /safe', and press Enter to launch Excel in Safe Mode.
Open your problematic workbook, click 'Refresh All' on the Data tab, wait for the refresh to complete, and then attempt to save the file.
If the file saves successfully in Safe Mode, restart Excel normally, navigate to File > Options > Add-ins, and disable your active COM and Excel add-ins one by one to identify the cause of the crash.
Refresh Queries and Pivot Tables Separately
Refreshing components individually instead of using 'Refresh All' reduces memory spikes and helps isolate problematic data connections.
Inspect and Remove Broken External Links
Corrupted workbook objects or invalid external links can corrupt the save process once a data model is updated.
Try WPS Office for Stable Spreadsheet Management
If Microsoft Excel continues to crash while processing complex queries and pivot tables, consider WPS Office. It is a free, lightweight, and highly compatible alternative that handles large datasets smoothly with a familiar interface, ensuring seamless workflow migration without the crashes.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your operating system.
- 2. Open Your Workbook: Launch WPS Spreadsheets and open your existing .xlsx file containing the queries and pivot tables.
- 3. Manage and Save smoothly: Update your tables and save your progress effortlessly without experiencing memory-related crashes.
Frequently Asked Questions
Why does Excel crash only when saving after a refresh?
Refreshing complex queries, pivot tables, and data models consumes significant RAM and CPU resources. When you initiate a save immediately after, Excel may run out of available memory or encounter conflicts with lingering background calculations, resulting in an application crash.
Can AutoSave cause Excel to crash during a refresh?
Yes, if AutoSave triggers while background queries are still actively pulling data, it can cause software conflicts. Try turning off AutoSave temporarily in the top-left corner, wait for the data refresh to finish entirely, and then save the file manually.
How do I find crash logs to share with Microsoft Support?
You can find crash details using the Windows Event Viewer. Press Win+X, select Event Viewer, navigate to Windows Logs > Application, and look for 'Application Error' events related to 'excel.exe'. You can export these specific logs to share with support alongside your sanitized workbook.
