Hello,
I am generating reports using pivot tables and slicers that are then each saved as a unique excel workbook. I run a macro to run through a list of slicer items, saving each workbook after the slicer is selected.
This takes a significant amount of time as my pivot tables (~30) refresh after each slice. I'm wondering if there might be something I can add to my loop to turn pivot table updating off, slice the table, turn Refresh-on-open on, save the file, and repeat. Maybe a combination of setting refresh-on-open to true, and setting pivot table manual updating to true?
Thoughts? Being that I have 30 pivot tables, is there a simple way to have the code change these variables for all pivot tables in the workbook (without having to do each one individually)?
Thanks!
I am generating reports using pivot tables and slicers that are then each saved as a unique excel workbook. I run a macro to run through a list of slicer items, saving each workbook after the slicer is selected.
This takes a significant amount of time as my pivot tables (~30) refresh after each slice. I'm wondering if there might be something I can add to my loop to turn pivot table updating off, slice the table, turn Refresh-on-open on, save the file, and repeat. Maybe a combination of setting refresh-on-open to true, and setting pivot table manual updating to true?
Thoughts? Being that I have 30 pivot tables, is there a simple way to have the code change these variables for all pivot tables in the workbook (without having to do each one individually)?
Thanks!