Pivot Data and Filter on separate sheets

  • Thread starter Christopher Robin
  • Start date


Christopher Robin

I'm sure, I've seen this set up, but can't seem to get it to work. I'm using
Excel 2007 and have inherited a rather complex analysis report based on 3
pivot tables. My current requirement is to include more detailed data for
the report, but this then causes an error that the pivot tables can not
overlap. So, what I'd like to do is have the filters on one sheet and the
actual raw data on another sheet that's hidden (the end user is more
interested in the charts than the raw data, which is hidden on the current
sheet anyway). I'm certain I've seen pivot tables set up like this, but,
naturally, never investigated it too closely, so I could be completely

Is this even possible? And if it is, how do I go about separating the two.





There's a couple of ways you could do this. Before you try this, make a back
up copy.

1. Create a Copy of the spreadsheet (Right click, Copy, Create Copy), Delete
the data from the new page (keeping the pivot table). The pivot table should
still be linked to the orginal page. Than, delete the pivot table from the
orginal page.

2. Recreate the pivot table on a new page, than delete the old pivot table
from the orginal data sheet.

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