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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top