Hi,
I can't find anyone else asking the question. I must be doing something stupid....
Does anyone know how to save pivot table layout?
Each time I get the pivot table set the way I want, so that user only needs to select from available options, it seems the layout disappears.
If I go to design view everthing goes back to step 1.
I want to have a pivot table that user can select from available filters and expand and contract only....not to create their own table.
Please help!
Thank you in advance.
JennieL
I can't find anyone else asking the question. I must be doing something stupid....
Does anyone know how to save pivot table layout?
Each time I get the pivot table set the way I want, so that user only needs to select from available options, it seems the layout disappears.
If I go to design view everthing goes back to step 1.
I want to have a pivot table that user can select from available filters and expand and contract only....not to create their own table.
Please help!
Thank you in advance.
JennieL