* Kindly Mark and Vote this reply if it helps, as it will be beneficial to more community members reading here. This module deep dives into the popular (and very useful) pivot tables. Remove hidden data and personal information by inspecting documents, presentations, or workbooks.Ĭlark - * Beware of scammers posting fake support numbers here. Video created by for the course 'Excel Skills for Business: Intermediate I'. I think you may try to recreate it in a newly created workbook(if it is not very complicated, copy your data to the new workbook) but not in the original one to avoid the issue is caused by some hidden information in the workbook.Īdditionally, inspect document feature may help find out some hidden contents in the workbook, you may inspect the copy of the workbook inįile>Info>inspect document, remove hidden information related pivot table, rebuild the pivot table and check the result. May I know how do you recreate the workbook? If the issue doesn’t happen in a newly created workbook, the issue could be related to this specific workbook. I already tried to recreate the whole workbook but keep experiencing the same issues. These pivot tables are next and above each other, as shown in the "ghost pivot tables" in the attached screenshot. My "pivot worksheet" has 6 different pivot tables that are all linked to the same source. Multiple users are experiencing this issue (link below). This disables slicers across charts because they are all technically pointing to different data sources. What can be the reason for this behaviour? This would be a minor issue but the duplicate queries mean that any subsequent pivot charts are connected to a duplicate of the original query. Only show the "data behind the numbers" but also some white "ghost pivot tables" that are linked to my other pivot tables in different worksheets. However, sometimes the newly opened window does not I suspect that the structure of my workbook and the implemented pivot tables might be an issue: Excel does not always crash when I double click a result in one of the pivot tables. This issues does not happen on a newly created workbook. I tried all your suggestions, but I unfortunately still experience this error.ġ.