Debra's write up on resetting the used range at has solved my problem.
Thank you all very much.
GeoObject
"Max" wrote:
Some thoughts ..
1. Try Debra's write up on resetting the used range at her:
http://www.contextures.on.ca/xlfaqApp.html#Unused
2. You may have pictures, drawings, etc on the sheet, some of which may even
be hidden or "squashed" into just a line. To select & clear all objects (do
this on a spare copy), on each sheet: press F5 Special check "Objects"
ok. Press Delete.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"GeoObject" wrote:
The workbook file size is 988,635 KB. Three files in all have sizes in this
range. Yet I only have 60 continuous rows with data on any one worksheet. Six
worksheet max.
Each worksheet will never have more than 1000 rows and the most worksheets
will be 10.
I am not experience with excel but this seems like a very large file for
such little data. the workbooks take 5 - 10 minutes to save and load.
each file eventually will not load and locks up the computer.
I am using Excel 2003 would it generally be better to move to 2007. Money is
not an issue.
Thank you