Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.

https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Excel Autofilter and PivotTable

4Sheets · 2011-11-02 17:35:16

I have googled this maybe not found the right link but what I have is a bunch of dynamic data and autofilter applied across the first row.I have another sheet some pivot table that update upon sheet activation. I would like the pivot table to display the data on the first page whether the filter is on or not.At the moment…

02-11-2011 06:35PM

#1

4Sheets

Closed Accounts Posts: 613 ✭✭✭

Join Date: July 2008

Posts: 581

I have googled this maybe not found the right link but what I have is a bunch of dynamic data and autofilter applied across the first row.I have another sheet some pivot table that update upon sheet activation. I would like the pivot table to display the data on the first page whether the filter is on or not.At the moment filtered data is ignored.I have a dynamic named range that is the pivot tables source.
One solution obviously enough is have a macro copy the filtered data to a new range and base the pivot table off this data.Is there a better way of doing this rather than copying the data to a new location?
Thanks folks!

0