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

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! ! ! !