big file

[Jo]

Hi
One of my files has suddenly increased in size from 52k to 1.27MB. I have
tried deleting all the cell round my 2 page doc, but to no avail. I am sure
it must be a formatting thing for all cells, but don't know what.
Help!
Jo

 

[Norman Jones]

Hi Jo,

See Debra Dalgleish's notes at:

http://www.contextures.com/xlfaqApp.html#Unused

 

[Don Guillett]

use ctrl+end to find the last cell. Then look to see if that is what you
really want.
If not, delete the rows/columns and SAVE.

 

[Alan]

You need to find the last used cell im the file then if for instance the
last used cell is AY954, in the name box enter 955:65536 > Enter, right
click and hit Delete, then in the namebox enter AZ:IV > Enter, right
clickand hit Delete. Save the file and check the size now,
Regards,

 

[Jo]

Hi
This doesn't seem to be the answer as i did delete all unused cells. I also
tried the format cleaner but still the same problem......
End cell fine!
Tahnks
Jo