Hello, I have created multiple Tabs in excel each with a Pivot Table. I would use the copy function to create each new tab and simply modified my pivot table by changing my filtration option "customer account number". I then refresh, and "clear filter from part", then create my "label filter". I'm doing this same step over and over until I will have 100+ tabs that represent different customers but all having the same overall format. The problem I'm experiencing is that some of the tabs will collapse (no longer showing the data it once was). I basically have to go through each step, refresh, clear filter from part, then create filter.
Solved by S. Q. in 24 mins