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

  • Thread starter Thread starter TC in CT
  • Start date Start date
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?
 
Would be usefull if MS could at least identify the worksheet name !!
 
You must log in or register to reply here.

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
Pivot table report invalid 0
2nd Pivot Table on Worksheet Crahes Excel 1
Pivot table wizards 2
loss of Pivot functionality in compatability mode 1
SOS!!! Excel 2007 Pitvot Tables Created in Old Format 2
One pivot table cannot overlap another pivot issue. 1
#name? 3

Back
Top