Fix Excel 365 Crashes When Refreshing Multiple PivotTables
Question details
The user needs to troubleshoot Excel 365 crashing while refreshing multiple PivotTables connected to Microsoft Analysis Services.
- Product
- Microsoft Excel 365
- Device & OS
- not provided
- Scenario
- Several PivotTables share an MSAS connection and need to be refreshed with current data.
- Observed behavior
- Excel 365 crashes when multiple connected PivotTables are refreshed, while refreshing them individually may avoid the crash.
Record the Excel version and build from File > Account, and confirm which PivotTables use the shared Microsoft Analysis Services connection. Save a copy of the workbook before testing refresh behavior or opening it in Safe Mode.
Update Office and test the shared PivotTables in Safe Mode
Use this first when the crash may be caused by an outdated Excel build or an add-in conflict.
Refreshing multiple PivotTables that share an Analysis Services connection can expose build-specific stability issues. Updating Excel and disabling add-ins helps separate an Office defect from an extension conflict.
Open Excel and select File > Account > Update Options > Update Now. Restart Excel after the update finishes.
Press Windows+R, type excel /safe, and select OK. Open the workbook in the Safe Mode window without enabling add-ins.
In the workbook, select a PivotTable, open the PivotTable Analyze tab, and choose Refresh. Repeat for each PivotTable instead of using Refresh All.
Close Safe Mode, then open File > Options > Add-ins. Select COM Add-ins from the Manage list, choose Go, and clear add-ins before testing the workbook again.
Use an older Excel version as a temporary workaround
Use this only when the current Excel 365 build continues to crash and the workbook must be refreshed immediately.
Use WPS Spreadsheet as a Lightweight Alternative for PivotTable Workbooks
WPS Office provides a free, lightweight spreadsheet environment with a familiar interface and strong Microsoft Excel format compatibility. Use WPS Spreadsheet to open, review, edit, and refresh supported workbook data while investigating an Excel 365-specific crash.
- 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheet from the Start menu or applications list.
- 2. Open the Excel workbook: Select Menu > Open, choose the XLSX or XLS file, and review the PivotTables and workbook connections.
- 3. Save a compatible copy: Use Menu > Save As and select Excel 2007-365 Workbook (*.xlsx) to create a Microsoft Excel-compatible copy.
Frequently Asked Questions
Why does Excel 365 crash when I refresh multiple PivotTables?
The crash may be caused by a specific Excel 365 build handling multiple PivotTables that share a Microsoft Analysis Services connection. Add-ins can also contribute to the failure.
How can I test whether an Excel add-in causes the PivotTable crash?
Press Windows+R, enter excel /safe, and select OK. Open the workbook and refresh the PivotTables. If the crash does not occur, disable COM add-ins through File > Options > Add-ins > Manage COM Add-ins > Go.
Should I refresh the PivotTables individually instead of using Refresh All?
Yes. Select each PivotTable and choose PivotTable Analyze > Refresh separately. This can avoid the crash when the failure occurs during simultaneous refreshes.
Where can I update the Excel 365 build?
Open Excel and go to File > Account > Update Options > Update Now. Restart Excel and test the workbook after the update completes.
Can WPS Office repair an Excel 365 crash caused by Microsoft Analysis Services?
No. WPS Office does not repair an Excel 365 or Microsoft Analysis Services defect, but WPS Spreadsheet can provide a free, lightweight environment for opening and editing compatible XLS and XLSX workbooks.
