If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Size of file with pivot table
I have a file that was 8MB when I started. I created a pivot table pulling 7
fields from a worksheet. Now the size is 20MB. Any ideas why this one pivot table would cause the file to be so large when the 8MB file already had pivot table sin it? When it was 8MB, it had 6 pivot tables. Now it's 20MB and it has 7 pitvot tables. Why is this one table so much larger? |
#2
|
|||
|
|||
Size of file with pivot table
Were the 6 PivotTable independent, or did they all use the same cache?
If you build PivotTables that use another PivotTable as reference (for when you're reference the same raw data, just taking a different look at it), they don't have to build a seperate PivotCache, and this significantly reduces file size. So, if the previous 6 were based on a single set of data, but the 7th is independent and/or based on a larger set of data, this could account for file bloat. -- Best Regards, Luke M "Nadine" wrote in message ... I have a file that was 8MB when I started. I created a pivot table pulling 7 fields from a worksheet. Now the size is 20MB. Any ideas why this one pivot table would cause the file to be so large when the 8MB file already had pivot table sin it? When it was 8MB, it had 6 pivot tables. Now it's 20MB and it has 7 pitvot tables. Why is this one table so much larger? |
#3
|
|||
|
|||
Size of file with pivot table
That's a great observation. I will look into this. Your response is greatly
appreciated. "Luke M" wrote: Were the 6 PivotTable independent, or did they all use the same cache? If you build PivotTables that use another PivotTable as reference (for when you're reference the same raw data, just taking a different look at it), they don't have to build a seperate PivotCache, and this significantly reduces file size. So, if the previous 6 were based on a single set of data, but the 7th is independent and/or based on a larger set of data, this could account for file bloat. -- Best Regards, Luke M "Nadine" wrote in message ... I have a file that was 8MB when I started. I created a pivot table pulling 7 fields from a worksheet. Now the size is 20MB. Any ideas why this one pivot table would cause the file to be so large when the 8MB file already had pivot table sin it? When it was 8MB, it had 6 pivot tables. Now it's 20MB and it has 7 pitvot tables. Why is this one table so much larger? . |
Thread Tools | |
Display Modes | |
|
|