Hi Guys
I've noticed that if I used slicers for awhile (say, 40 -> 60 variations) & then save the workbook, the workbook size will increase from 4MB to about 6MB. Also, loading times increase significantly to around 30 seconds -> 3 minutes.
I currently have my worksheets using cubed data and I assume PP is caching my slicing selections. How do I prevent this from happening?
Thanks!
I've noticed that if I used slicers for awhile (say, 40 -> 60 variations) & then save the workbook, the workbook size will increase from 4MB to about 6MB. Also, loading times increase significantly to around 30 seconds -> 3 minutes.
I currently have my worksheets using cubed data and I assume PP is caching my slicing selections. How do I prevent this from happening?
Thanks!