Good day
Thanks alot to all of you, i guess the problem was with macros. I saved it
as an .html file and then export it to excel and it worked! Now the file is a
60 kb file instead of 1Mb.

thanks for taking the time to solving others people's troubles.

"dominicb" wrote:


Good morning Oglu

Any macros? Multiple macro editing can cause exessive file size.

Alternatively try this. File Save As... Select Web Page as the file
type, then Entire Workbook and click OK. Close Excel. Reopen Excel
and open the file from the HTML format. Now save the file back as .xls
format. Does that decrease the size for you?

Don't forget to delete the HTML files - they're no longer needed.

HTH

**** I've never had a problem using this trick, but only do it on a
file you have a recent back up of ****

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=396739