View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
GeoObject GeoObject is offline
external usenet poster
 
Posts: 3
Default want to limit worksheet to 1000 rows instead of 65,000


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