Overlapping Pivot reports

M

meesh1224

I have created a template in excel for which I extract data from MS project
and create privot reports to get different slices of information. I am able
to easily use the template for the project data for which I created it.
However, when I try to copy in data from other projects I get an error
message stating "A pivot report cannot overlap another pivot report." The
data the is being extracted from the projects are in the same format and are
the same colums.
What am I doing to get this error and how do I correct it.

Thanks,
Michelle
 
M

meesh1224

I figured it out.
The data that I was pulling in was greater than the space I had allowed
before the next report. I had more than one pivot report on a worksheet. It
was literally overlapping the lower report. I simply added additional reports
between the reports.
 
Top