No, the pivot table uses all the source data, not the filtered table.

You could use an Advanced Filter to extract some of the data to a
different worksheet, then base the pivot table on that.

carl wrote:
Can the pivot table feature be set-up to only apply to unfiltered data - for
example if my worksheet has a column filtered.

Thank you in advance ?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html