cmcreynolds
Active Member
- Joined
- May 21, 2015
- Messages
- 295
I have a file that seemed to really jump in file size when I added a power pivot table. There aren't really that many records (maybe 25k?) but I have three filters plus a slicer and a timeline. Could the filters and slicers be causing it to increase the file size so much?
With the worksheet with the table, my file is 95Mb. I saved a copy and deleted that one worksheet and it decreased to 4Mb.
It isn't detrimental to my work, but it does load to OneDrive extremely slowly.
Just wondering if I could tweak the pivot table to decrease the size.
With the worksheet with the table, my file is 95Mb. I saved a copy and deleted that one worksheet and it decreased to 4Mb.
It isn't detrimental to my work, but it does load to OneDrive extremely slowly.
Just wondering if I could tweak the pivot table to decrease the size.
