"A pivot table report cannot overlap another pivot table report"

  • Thread starter ExcelPowerUserWannaBe
  • Start date
E

ExcelPowerUserWannaBe

I thought I was getting this message when I refresh one pivot because I had
multiple pivot tables on a worksheet. Whether I select Yes or No
("overwrite" or "don't overwrite") it deletes data from the two pivot tables
to the right of it (the rest of the pivots to the right retain their data).
I added columns to the right and bottom of the pivot to make the space I
thought it needed -- but I still got the message. I then copied one of the
pivots to a new worksheet, but still got the message. Any ideas? PLEASE
HELP! ! ! !
 

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

Top