How to Reduce Excel File Size Finally Revealed !

[earthworm]

Hi All,

I am sure most of the user have one complain .

1) The size of my excel file has become very large example 45-90 MB
2) Due to Above file size i am unable to perform further action on that file due to error (limited resource available)

The Answer to the above question has finally solved after perform several testing

A) If you have locked the sheet with option "Lock and Hidden Cell" of the entire sheet i.e ctrl+a +a (selecing entire sheet cell) , then the file size will increase significantly because after selecting the entire sheet i.e Data and other unused blank cell and selecting the option " Lock and Hidden " , the same is applied on each and every cell i.e 1 million + cells rows and columns , due to this the file size becomes huge.

in order to reduce the file , make sure that only those cells are lock and hidden on which data is present , remaining is not necessary .

In a nut shell , the option " Hidden " is the root cause for this .

Enjoy !!!

 

[mikeloveta]

select the sheet in which data is present press ctrl+a+a to select entire sheet , go to cell properties and click on lock tab , and uncheck hidden and lock option , and save the file . then see the result .

Thank you for this. Very helpful!