Forum Discussion

Copper Contributor

Oct 04, 2023

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 ...

Copper Contributor

Oct 31, 2023

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)

Jindra_Kubec

Copper Contributor

Feb 25, 2024

The problem was solved with build 2401 of Excel 365/2021.

The problem was caused by adding/renaming dimension attributes in OLAP :o(

In previous builds we needed to delete all attribute changes to "solve" the problem with crashing Excel during refreshing pivot tables.