Refresh Pivot Table Error

[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

 

[Guest]

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.