Size of file with pivot table
in [Functions]
|
Prev: Calculating Bond Amortization using Excel functions
Next: extract data from pivottable which meets certain conditions
From: Nadine on 3 Jun 2010 19:57 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?
From: Luke M on 4 Jun 2010 08:24 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" <Nadine(a)discussions.microsoft.com> wrote in message news:52904245-0290-44BC-B4D8-907CF9FB452A(a)microsoft.com... >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?
From: Nadine on 4 Jun 2010 16:44
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" <Nadine(a)discussions.microsoft.com> wrote in message > news:52904245-0290-44BC-B4D8-907CF9FB452A(a)microsoft.com... > >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? > > > . > |