reduce excel file size

[Eric]

The excel file I'm working in seems to keep growing and
growing in size. How do I compress or reduce the file
size. I think the program remembers all the steps I make
in the program and keeps track of them making the file
bigger and bigger. If anyone could help with this, it
would be appreciated. Thanks

 

[Alan]

You could try this, use Ctrl > End to find the cell that Excel thinks is the
last used cell then find your ACTUAL used cell. Delete the entire rows and
columns past this cell, you must delete them, clearing contents wont do it,
save and exit, re-enter and see what the file size is now,
Regards,

 

[Nick Hodge]

Alan

You instructions are correct except you do not need to exit from Excel.
This step, I believe became unnecessary after V5

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Alan]

Really?
I didn't know that. Thanks for the tip. What is V5 in terms of XL97, 2000
etc? I believe it to be 97 but I'm not sure,
Regards,
Alan,

 

[Peo Sjoblom]

None of them, excel 5 came 93 and then we had 95 and finally 97 which is
basically the same as 2003.
A big change happened between 95 and 97 with the introduction of VBA and
some other things

http://www.j-walk.com/ss/excel/index.htm

 

[Nick Hodge]

Peo

Don't want to get pedantic, but was VBA not introduced in V5 and continued
in 95 (V7) on code modules (sheets). The biggest change between XL95 (V7)
and XL97 (V8) was the file structure and a move from 16k (and a few) rows,
to 65536 and the introduction of the VBE interface?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Peo Sjoblom]

Yes, correct you are..

 

[Peo Sjoblom]

Oops! Hit the send button too fast, it was Word that got VBA with 97,
I switched history between the two <g>