software

All,

I have a pivot table that is based on a huge set of data (c. 3,000
rows). The pivot works fine but if you filter the source data then the
pivot (when updated) will only pick up the data that is shown after the
filter. I want to be able to analysis the original data without
worrying about the effects on the filter.

Any Ideas?--
chalky
------------------------------------------------------------------------
chalky's Profile: www.excelforum.com/member.php...oamp;userid=23758
View this thread: www.excelforum.com/showthread...hreadid=495745Chalky,

Is your pivot table on another sheet? Pivot tables should not be affected by hidden or filtered
rows in the data source unless they are displayed on rows that are hidden by the filtering process.
Simply move your table to another sheet, and you should be fine.

HTH,
Bernie
MS Excel MVPquot;chalkyquot; gt; wrote in message
...
gt;
gt; All,
gt;
gt; I have a pivot table that is based on a huge set of data (c. 3,000
gt; rows). The pivot works fine but if you filter the source data then the
gt; pivot (when updated) will only pick up the data that is shown after the
gt; filter. I want to be able to analysis the original data without
gt; worrying about the effects on the filter.
gt;
gt; Any Ideas?
gt;
gt;
gt; --
gt; chalky
gt; ------------------------------------------------------------------------
gt; chalky's Profile: www.excelforum.com/member.php...oamp;userid=23758
gt; View this thread: www.excelforum.com/showthread...hreadid=495745
gt;