Reduce excel file size

[Noone]

Is there any way to reduce the excel file size?

I' am using a calculation sheet, which I customize everytime for a different
project.
It looks like the file somehow retains a hidden record of all file changes
and the file grows over time. At this moment the file is roughly 9Mb!
I removed all the names which I don't use anymore plus all the macros. It
does help a bit but not enough. The weird thing is that if I start of a
clean spreadsheet, and copy the formulas from the old to the new one. The
new one is just a few 100kb.

Any ideas, how to get rid of some of that "MS Intelligence"?

Michael

 

[Gord Dibben]

Michael

Excel has a habit of retaining "used" cells way beyond where you are currently
working.

On a worksheet hit CRTL + END to see where you wind up.

If far below and to the right of your real used range then select the row
below where your real used range is and SHIFT + END + DownArrow. This selects
all rows to the bottom of the sheet. Edit>Delete>Entire Row.

Do the same for columns to the right of your range.

Repeat on all sheets.

Important step now.........SAVE the workbook. In some cases it may be prudent
to also CLOSE after Saving then re-open.

There are other ways to reset the used range. Debra Dalgleish has some code
at her website.

Gord Dibben XL2002

 

[Noone]

Gord,

Thanks a bunch! I'll give it a try.

Michael

 

[Evan]

I couldn't get it to work very well with 2000. Found instead

Select row just below real data
Ctl-Shift-End
Edit > Delete > Entire row

Repeat for columns, save, re-open. The trick seems to be finding the
end of real data in complex situations. Maybe double clicking the
bottom or right side of a data cell will get you there.