PivotTable Error: A pivot table cannot overlap another pivot table report

[sroe]

Hi!

My question is: I am trying to refresh a pivot table and I get an error message "A pivot table cannot overlap another pivot table report". This is a spreadsheet that was passed onto me from another co-worker. To be honest with you I know how to bulid a pivot table but I do not know how to manipulate one. I read online about macros but I am not sure how to set one up to find the problem and then how to go on and fix it.

Please advise.
Thank you!

[AAE]

Welcome to Ozgrid.

Pivot Tables should be on their own sheet.

Try moving the PT to a new sheet

[sroe]

Thank you! I will try this. I appreciate your help with this