Excel Size

[Surekha]

Hi Team,
I have excel which contains more than 80 sheets, with 27 pivot. Each sheet will not have data more than 10000 rows. I saved the file in binary format but still file size is more than excepted( it around 35 MB). File doesn't contains any object in it. When I delete unwanted rows and columns file size will increase instead of decreasing. Please help me to resolve this.

 

[GraH - Guido]

Hi,
I suspect some pivot cache issues.
- Do some of the pivots share the same data, or do they all refer to other datasets?
- Is the pivot data in the same file, or not?

Already try to set "save pivot data with file" to false (uncheck the flag), for each of the pivots. See if that has any effect at all.

 

[pecoflyer]

Perhaps have a look at https://trumpexcel.com/pivot-cache-excel/

 

[Deepak]

You may share the file if issue exists yet.

 

[Chihiro]

80 sheets sounds excessive. Consider splitting workbook to smaller chunks. Typically, I'd recommend keeping sheet number in a given workbook to 20 or less (though I prefer less than 10).

On top of PivotCache others have mentioned... check each sheet's used range by using CTRL + END. If the selected cell is beyond your data range, then you'd need to select those ranges and use edit tool to clear all.