If you meant the pivot table would only deal with the visible data, then the
answer is no.

You could filter the data and copy it it do a new location, then use that as
the source for the pivot table.

Can't you reproduce the filtering using the pivot table itself?

--
Regards,
Tom Ogilvy


wrote in message
...
Is it possible to create a PivotTable with a filterred
list ?