Forum Discussion
Named pivot table creates ghost pivot tables on show report filter pages
Link to Ghost Pivot Table Video
I've since realized that the named table behaves no differently than unnamed. Took a step back and realized that I had many more pivot table objects in the workbooks than expected or visible.
Essentially multiple ghost tables are created in each pivot table tab created.
And, attempting to insert new worksheet when a pivot table tab is active also creates a ghost pivot table regardless of presence of Page Filters.
A test file is attached which includes a brief description of the test steps executed along with the account information requested. I'm also attaching a video of the overlapping message as the ghost tables are created. (Note, that the test data is the same size for each group. When size is different visible pivot table is inconsistent with ghost pivot table.)
Attempts to save this test file after removing personal information shut down EXCEL which immediately reopened. If that become relevant, I will recreate a new test file.
We began experiencing unacceptable instability in mid-December, but cannot confirm whether/if that correlates to any updates. There is one similar ghost pivot table discussion on the support boards with an official recommendation to change Office 365 channel from monthly to quarterly and rollback to Version 1902 (Build 11328.20492) . Our IT department was not comfortable making that change so rolled back on the monthly channel to Version 1910 (Build 12130.20410) and stopped all future updates.
Link to similar support discussion
- I can't repro all of your issues, but I do see some, like the overlapping PT error. I also had Excel crash on my when I tried to delete a couple of sheets. I think the file contains corruptions and needs to be rebuilt.
Thanks for your observations. I agree that the file has corruptions. Those corruptions appear to be related to standard pivot table functionality. More importantly, rebuilding years and years of work on complex models (that worked without issue and then in the last 3 months didn't) is not an option. Deleting worksheets with ghost pivot tables will crash EXCEL every single time. Repairing the files removes all pivot table objects. I suppose I could test for ghost objects and then specifically try to remove them vs deleting worksheets. If that worked, at least we might quasi-manage risk. That's not acceptable as a final solution though.
- I've sent the Excel team a link to this discussion thread to draw their attention to it, doesn't feel good this issue.
