Named pivot table creates ghost pivot tables on show report filter pages

Howie Dickerman 

With some new information, here are additional test observations.

Thanks for your comments which informed additional testing.

Macro security set to disable with notice.

Access to library disabled.

Created a completely new file with no other files open.
No VBA module or macro in the file.
Built worksheet tab with records.
Created pivot table sourced from those records with NO page filters.
Remained on the pivot table worksheet and inserted a new worksheet.
No ghost pivot table.
Moved a pivot table field to the page filter.
Remained on the pivot table worksheet and inserted a new worksheet.
Ghost pivot table created.
Moved to the data worksheet.
Inserted a new worksheet.
No ghost pivot table.
Saved the file.
Opened a blank worksheet.
Closed the test file.
Excel crashed, immediately relaunched and opened test file.
Document recovery message indicated original test file was recovered.  
Book1.xlsx created prior to closing test file was not recovered.
(An Application Error and Windows Reporting was logged indicating APPCRASH associated with EXCEL)
This test suggests to me that pivot table page filters contribute to our ongoing instability.
While we can certainly not use page filters going forward, that does not mitigate risk associated with existing complex models already constructed with page filters.
With the macro variable removed, I'd appreciate you taking another look.

Thank you.

Howie Dickerman  JKPieterse 

Cannot thank ALL of you enough.  I look forward to learning what the engineers discover.