reduce excel file size

  • Thread starter Thread starter Eric
  • Start date Start date
E

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
 
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,
 
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)
 
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

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)
 
Oops! Hit the send button too fast, it was Word that got VBA with 97,
I switched history between the two <g>
 
Back
Top