Hi,

Is it possible to save a pivot tables characteristics for later use (not just filtering)? There are many different pivot table views of the same data that I'm constantly needing to present. I'm hoping that I won't have to create multiple pivot tables in the one file (to reduce file size/not have to refresh a ton of tables).

I've read there's something w/ Slicers that help some people, but I believe slicers only adjust filtering and not which columns are included, and in which of the 4 pivot table sections. I want to be able to save versions of completely different pivot table formatting (i.e. changes to 'Report Filters', 'Column Labels', 'Row Labels', 'Values'). Hoping to save about 10+ versions that I can toggle between

Would rather not have to write a macro, if avoidable

I really hope this is possible!
Thanks!