Pivot Data and Filter on separate sheets

[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
mistaken.

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

TIA,
Chris

 

[AFSSkier]

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.