Hello!
I have a pivot table with two filters. The first filter encompasses multiple items denoted with an * at the end (M17002*), the second filter generally has a specific item (63266-A). Without the filters, the pivot table updates upon hitting the refresh button, however WITH the filters set, it does not. I have multiple sheets with the same pivot table format that feeds off of the same data. Is there a way to have the pivot table update?
Any help will be greatly appreciated!
Thank you in advance!
I have a pivot table with two filters. The first filter encompasses multiple items denoted with an * at the end (M17002*), the second filter generally has a specific item (63266-A). Without the filters, the pivot table updates upon hitting the refresh button, however WITH the filters set, it does not. I have multiple sheets with the same pivot table format that feeds off of the same data. Is there a way to have the pivot table update?
Any help will be greatly appreciated!
Thank you in advance!