How to reduce Excel file size from 17.2 MB

[chaka]

I have a large Excel file used for financial modelling
purposes - it is about 2 MB large, containing many macros.

After I added three small new macros, and imported some
worksheets from other Excel files I was shocked to
discover the file size had increased to 17 plus MB. now
my ISP won't accept it in my e-mail!
How can I determine where / how to reduce the file size?
I notice that when I look in my macro's that I still have
the choice of choosing all open workbooks or the one
currently open, as if there should be a choice even though
I have only one workbook open.
I must have done something strange.
Any help gratefully accepted.

 

[Ron de Bruin]

Try to reset the Usedrange Chaka

http://www.contextures.com/xlfaqApp.html#Unused

 

[chaka]

Hartelik bedankt, Ron - always nice to hear from a
Hollander, as both my parents were.
I solved my problem while I was waiting for the reply.
I had made the mistake of formating three or four columns
without realizing that I had included the colour and
border format all the way down to the very bottom of the
spreadsheet.
I highlighted rows 100 through 66,000 plus and
applied "clear all" and I was back to my orignal file size.

-----Original Message-----
Try to reset the Usedrange Chaka

http://www.contextures.com/xlfaqApp.html#Unused

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




"chaka" <[email protected]> wrote in

message news:[email protected]...

 

[Ron de Bruin]

Hartelik bedankt, Ron
Graag gedaan

Greetings from the Netherlands