Forum Discussion
Excel 365 (version 2307&higher) crashes when refreshing pivot tables (more pivot tables at once)
Dear all, I am currently experiencing the following problem in Excel 365 version 2308 with pivot tables (on MSAS connections): Excel always crashes if I'm refreshing data for all connections ...
I’m sorry to hear that you’re experiencing this issue with Excel 365 version 2308. It seems like a complex problem that might be related to the specific version of
Excel and the way it handles refreshing data for multiple pivot tables at once.
Based on the information you provided, you’ve already tried a number of troubleshooting steps and found a workaround that involves using an older version of Excel. While this workaround is effective,
I understand that it’s not an ideal solution.
Here are a few additional suggestions you might consider:
Excel Safe Mode: Try opening Excel in Safe Mode. This starts Excel without any add-ins or extensions, which can sometimes cause problems.
Update Excel: Make sure your Excel application is up-to-date. Microsoft frequently releases updates that can fix bugs and improve performance.
Excel and the way it handles refreshing data for multiple pivot tables at once.
Based on the information you provided, you’ve already tried a number of troubleshooting steps and found a workaround that involves using an older version of Excel. While this workaround is effective,
I understand that it’s not an ideal solution.
Here are a few additional suggestions you might consider:
Excel Safe Mode: Try opening Excel in Safe Mode. This starts Excel without any add-ins or extensions, which can sometimes cause problems.
Update Excel: Make sure your Excel application is up-to-date. Microsoft frequently releases updates that can fix bugs and improve performance.
Thanks for your advice, but unfortunately it doesn't work. Excel in SafeMode also crashes.
I tried this on multiple Excel versions (2307, 2308 & 2309)
here are a few additional suggestions you might consider:
Check for Add-ins: Some add-ins can cause problems with Excel. Go to File > Options > Add-Ins. At the bottom of the dialog box, change the Manage dropdown to COM add-ins, and select Go. Clear the checkbox for any enabled COM add-ins.
Repair Excel: You could try repairing your Excel installation.
Click Start, in the search box type Run. In the Run box, type appwiz.cpl and click OK. Select Microsoft Office 365, click Change>Online Repair>Repair
- I tried all your suggestions. excel crashes even on a new PC with new instalation of Excel 365 version 2307 & higher.
This problem comes with Excel 365 version 2307 - Pivot table overlaping
... for old Excel files (pivot tables were created in Excel 2010/2013)
