LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.newusers
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




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i limit my worksheet size to say 11 columns and 11 rows. Richard New Users to Excel 1 August 24th 06 05:32 PM
is there a limit to the number of rows a worksheet can have? Debi Excel Discussion (Misc queries) 2 May 22nd 06 02:47 PM
How do I limit the number of rows displayed on a worksheet? cms31 Excel Discussion (Misc queries) 4 December 8th 05 06:20 PM
Increase rows in worksheet beyond 65,536 row limit Ann Calantzis Excel Discussion (Misc queries) 2 February 25th 05 01:33 PM
How do I limit the number of rows in an Excel worksheet. laforge27 Excel Worksheet Functions 1 November 4th 04 01:42 AM


All times are GMT +1. The time now is 05:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"