xls file blown up?

  • Thread starter Thread starter Tobias Gårdner
  • Start date Start date
T

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
 
No, that does not work. I save to a new filename at least once per day to
keep some kind of revisionhistory.
// Tobbe
 
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.
 
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
 
Back
Top