Forum Discussion
Named pivot table creates ghost pivot tables on show report filter pages
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.
Thank you so much. I've scoured every message board and resource I can think of and barely found a toe hold. Appreciate the assist.
TLM_MI Hi - I'm a program manager on the Excel product team and I'm asking our engineers to investigate. We have another report of a problem that sounds like it might be similar but it's hard to know for sure until the engineers take a look. In any event, we'll take a look and I'll let you know what we find. Thanks for posting this, and thanks also to Jan Karel Pieterse for calling the issue to our attention.
Thanks,
Howie Dickerman
