How do I locate overlapping pivot table reports in Excel 2003?

T

TC in CT

When opening a very large Excel workbook with several tabs that reference two
key data entry tabs, I get a pop up that says "A pivot table report cannot
overlap another pivot table report." Is there a way to quickly identify
which pivot table reports are in conflict without having to analyze each
pivot table report in the workbook?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 Pivot Table Disappears 1
loss of Pivot functionality in compatability mode 1
Pivot table wizards 2
how do i refresh a pivot table report in a shared file 1
Pivot tables - Editing the data source shared by multiple pivot ta 1
Excel 2007 Pivot Tables compatible with 2003 3
Excel 2010 Slicer Connection / Pivot Table Problem 3
How to base a pivot table on another pivot table? 3

Top