Hi all!
I have created a workbook with a sheet containing a large number of Pivot tables. A second worksheet consists of Pivot charts linked to these tables.
Each activation of the second worksheet causes a problem with the workbook. The user interface seems to be frozen and it is impossible to continue work (see attachment).
The only solution is to cut one of the Pivot charts and paste it again in the worksheet. After this, the UI is normal again. So i created a macro which takes the first chart in the activated sheet and cuts/pastes it. But this takes a few seconds and is quite annoying.
Is this an Excel bug? Has anyone experienced the same problem? I also found out that this problem only occurs when more than one Pivot chart is used in a sheet.
Thanks for your help!
Best regards, Phil
Bookmarks