Microsoft Excel - Pivot table - Asked By dany on 07-Jun-10 11:23 AM

Hi,

when I try to update my pivot table after I have inserted the new data in another worksheet I get this error:

" A pivot table report cannot overlap another pivot table report"! What can I do?

Many thanks,
Dany

Hi Dany,

Because one pivot is now bigger than last time, it uses cells that are designated for another pivor table. So you have to move the second pivot a little to the right or down .

Go into VBA an change the pivot table destination. Or when you are recording it all , record it again with more space for each pivot.

Best Regards :)

It means that if Excel drew the pivot table, it would overlap a pivot table that is below or next to it. Excel does not insert rows when it draws a pivot table. the solution is to insert rows or columns before making the change.