Increased size of an excel file

DG83 Posts 38 Registration date Monday January 2, 2012 Status Member Last seen April 21, 2018 - Mar 11, 2013 at 10:31 AM
 Dg83 - Mar 11, 2013 at 05:03 PM
hi guys,

I have come across an interesting issue. I redid some tables in an excel file and when done with it I see that the size of the file is at least 15x more than it should be. I dont see any reason for that. So my question is, what can be done in such a case to trace back to why it could have ballooned up in size. It must have happened to others as well I suppose.



1 response

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Mar 11, 2013 at 04:01 PM
Hi DG83,

In my case this happened when I accidentally applied formatting to the entire sheet instead of some fixed cells such as a table. For example, there is a possibility you might have applied the table's formatting such as background color, border style, fonts, etc. for the entire sheet. Try removing the formatting from the parts of the sheet where it is not needed and check if the size gets to normal.

Do reply with results.
I was able to download an excel add in that cleared the formatting which resolved the issue. I think it was called clearall.