Refresh Pivot Table Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a pivot table based on another pivot table and it has worked
fine until today when I got an error msg "A pivot table cannot overlap with
another pivot table".

Can anyone tell me what have I possibly do wrong?

Thank you,
Natalie
 
Hi Natalie,

It sounds to me like your latest refresh will cause your pivot table to
expand to add either columns or rows (or both). Do you have another pivot
table that is adjacent to the one you are trying to refresh?

If that's the case, try inserting a number of rows/columns between the
current pivot table and the other one.
 
Back
Top