xls file blown up?

[Tobias Gårdner]

Hi,

I have an xls file that has become very large. When I saved the file
2003-12-09 it was approx 350KB. When I saved it the 10th it was over 3MB. I
have NOT added anything put a small amount of text and numbers to the file
between those two dates.

Does anyone know if it is possible to shrunk the file again?

Regards,
Tobbe Gårdner

 

[Arvi Laanemets]

Hi

Try to save it to another name (Save As)

 

[Tobias Gårdner]

No, that does not work. I save to a new filename at least once per day to
keep some kind of revisionhistory.
// Tobbe

 

[Arvi Laanemets]

Hi

Not easy to solve then! Any hidden rows/columns or hidden sheets there? What
does WBA-Project manager (Alt+F11) show - aren't there some very hidden
sheets, or some unusual code?

Is your file shared? When shared, remove sharing/protection and try to save
to another name again.

Another try - select all worksheets holding down Ctrl key, and then try
MoveOrCopy to new worksheet.

The last one - copy contents of all worksheets (actual used dataranges, not
whole sheets) into new file, using PasteSpecial.Formulas,
PasteSpecial.Formats and PasteSpecial.ColumnWidths simultaneously.

 

[Gord Dibben]

Tobbe

Excel sometimes gets an inflated idea of where your data range stops. Perhaps
you entered something in a cell far below where your range ends then cleared
it. Excel still counts this as part of your used range.

Hit CRTL + END and see where Excel takes you.

Select all rows below your real data range...SHIFT + END + DownArrow.

Edit>Delete>Entire Row.

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

You must do this on each sheet.

Save and Close then reopen the file.

Debra Dalgleish has more info and a VBA method of re-setting the used range.

http://www.contextures.on.ca/xlfaqApp.html#Unused

Gord Dibben Excel MVP