Good afternoon,
I have a pivot table that will be growing over time as end users add more source data and refresh it. Is there a way to add a macro that will check "Show All" within the pivot fields themselves even after new data is added?
I've seen multiple options on the board for having the macro that checks "Show All" but have yet to see one that can continuously still show all data after new data has been added to the table.
Thanks!
Jeff
I have a pivot table that will be growing over time as end users add more source data and refresh it. Is there a way to add a macro that will check "Show All" within the pivot fields themselves even after new data is added?
I've seen multiple options on the board for having the macro that checks "Show All" but have yet to see one that can continuously still show all data after new data has been added to the table.
Thanks!
Jeff