T Tom Ogilvy Oct 22, 2003 #2 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?
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?
