• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Auto refilter a Pivot table after new raw data import

B

Brucemac

New Member
I have built a sheet where there is a raw data sheet with about 30,000 lines. Each month a new set of data is posted.
On tab 2 I have pivot tables based on the raw data. I have the zero values filtered out for most of the pivot tables.
When I do a refresh, it still uses the same data values based on the last time I set the filter not the newly posted data.
I have to "select all" then deselect 0 again to have a properly filtered list for the table.

Not a huge effort but....I have 30 pivot tables based on the raw data tab all with zero filtered out.

Is there an easier way to do this without coding.
 
Have you considered or looked at bringing your data into Power Query and running your pivots from there. With this method, each time your original data is amended/changed, it is automatically accounted for in PQ and the resultant PTs by clicking on the Refresh All Button.
 
You must log in or register to reply here.
Back
Top