Heavy file while empty

my guess would be you have a bunch, 42K, of styles that got indirectly installed..look at all those currency styles..thanks Microsoft....here is a macro that deletes non-standard styles....

Please Login or Register  to view this content.

I didn't write StyleKill and I would give them credit if I could remember who did....sorry

that is very peculiar, I even added a sheet and deleted the old one and it still came up very large.
Didn't even notice the styles

Hi Xtazer and welcome to the forum,

Newer .XLSX files are really zipped files to save space. If you rename your file to a .zip file and look at the components you will find "Styles" are taking up all the extra room.
This is a very strange problem but the extra bloat is in Styles kept in this individual workbook.

@ judgeh59 ..
http://excelribbon.tips.net/T012259_...ed_Styles.html

And here is another one.. for OP..
http://support.microsoft.com/kb/291321

Thanks for the update Debraj

Just emphasizing Marvin's post..

Change the file name from heavyFile.xlsx to heavyFile.zip
Now Unzip it with any unzipper..
You will found something like this..

Capture.JPG

Now in XL Folder, check out the "styles.xml" file, or read it in XML editor / IE..

Here is a tool that claims to remove the extra styles. I've not used or tested it but it claims to do the trick.

http://xlsgenreduction.arstdesign.com/index_en.html