memory growing spreadsheet

J

JohnUK

Hi Again
I have another query-
For some reason when working on a spreadsheet it can
start with say, 925kb in size,I do a couple of changes,
then "Wolla" 10+mb
It only happens every now and again, but I have tried
copy then paste special, taken all macro's out, save as a
different name,copy sheet into different book, but still
can't bring it back down in size, "Hu" I even took my
changes back out
What is going on?
John
..
 
D

David McRitchie

Hi John,
What are you doing? Whatever it is, I think I'd want to do something
else. But I haven't any hint what to avoid doing <grin>. Perhaps
you have a macro making a changes to huge selections rather
than just what should be changed. Did you install an addin recently.

The first thing I'd check would be your last cell [Ctrl+End]
http://www.mvps.org/dmcritchie/excel/lastcell.htm#resetall
http://www.mvps.org/dmcritchie/excel/lastcell.htm#makelastcell
Don't forget to save your file for changes to occur.
 
O

Otto Moehrbach

John
This is usually caused because Excel thinks the used range on your
sheets is much bigger than you intend it to be.
For each one of your sheets, scroll to the last column and last row of
your actual data. That gets you a cell address. Now do Ctrl - End. This
takes you to the cell that Excel thinks is the last cell of your data. If
this cell is significantly far away from the cell you thought was your last
cell, then that may be your problem.
You fix this problem as follows. For each sheet, do this:
Say your last actual data cell is G100.
In the name box (right above column A), type 101:65536 and hit Enter.
This selects every row from row 101 to the bottom of the sheet.
Do Edit - Delete
Again in the name box type H:IV. This selects every column from H to the
right end of the sheet.
Do Edit - Delete
Do this for every sheet.
Save the file.
Close the file.
Open the file.
Done.
HTH Otto
 
Top