big file 2

[Jo]

Hi
This does not make a difference to the file size.
I can copy the data to a new work book and this makes 1.27MB file 52k.
This is not practicle for workbooks woth numerous sheet, slso I would like to
understand the problem.
Thanks
Jo


Delete the ROWS and COLUMNS .

--
Don Guillett
SalesAid Software
(e-mail address removed)

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

Expand AllCollapse All

Manage Your Profile
©2004 Microsoft Corporation. All rights reserved. Terms of Use |Trademarks
|Privacy Statement

 

[Ron de Bruin]

Have you read this on Debra's site

Save the file. Note: In older versions of Excel, you may have to Save, then close and re-open the file before the used range is
reset.

 

[Jo]

tried that too
really at a loss
thanks
Jo

Have you read this on Debra's site

Save the file. Note: In older versions of Excel, you may have to Save, then close and re-open the file before the used range is
reset.

 

[Ron de Bruin]

(Solution found<private mail>)

There where objects in the file

F5 >Objects
OK

All objects are selected now
Press delete
Save the file