| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
want to limit worksheet to 1000 rows instead of 65,000
My worksheets only need 1000 rows but the worksheet remains at 65,000+ rows.
I have 1 GB or ram and 6 worksheets causes problems. How can I set a default to limit the max number of rows and columns. Thank you |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
want to limit worksheet to 1000 rows instead of 65,000
All (pre-XL07) worksheets have 65536 rows. That can't be changed.
However, unused rows don't take up any memory or disk space, so there's no need to try to limit them. What problems are you having? In article , GeoObject wrote: My worksheets only need 1000 rows but the worksheet remains at 65,000+ rows. I have 1 GB or ram and 6 worksheets causes problems. How can I set a default to limit the max number of rows and columns. Thank you |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
want to limit worksheet to 1000 rows instead of 65,000
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 "JE McGimpsey" wrote: All (pre-XL07) worksheets have 65536 rows. That can't be changed. However, unused rows don't take up any memory or disk space, so there's no need to try to limit them. What problems are you having? In article , GeoObject wrote: My worksheets only need 1000 rows but the worksheet remains at 65,000+ rows. I have 1 GB or ram and 6 worksheets causes problems. How can I set a default to limit the max number of rows and columns. Thank you |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
want to limit worksheet to 1000 rows instead of 65,000
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
want to limit worksheet to 1000 rows instead of 65,000
988,635 KB is 988 MB...............!!!
I think maybe you have 988,635 bytes which is not overly large but resetting the used range should bring that number down quite a bit. See Max's post with the link to Debra's site. Gord Dibben MS Excel MVP On Sun, 8 Apr 2007 12:24:04 -0700, 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 "JE McGimpsey" wrote: All (pre-XL07) worksheets have 65536 rows. That can't be changed. However, unused rows don't take up any memory or disk space, so there's no need to try to limit them. What problems are you having? In article , GeoObject wrote: My worksheets only need 1000 rows but the worksheet remains at 65,000+ rows. I have 1 GB or ram and 6 worksheets causes problems. How can I set a default to limit the max number of rows and columns. Thank you |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
want to limit worksheet to 1000 rows instead of 65,000
Good to hear that. Thanks for feeding back to us what worked for you.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "GeoObject" wrote in message ... Debra's write up on resetting the used range at has solved my problem. Thank you all very much. GeoObject |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i limit my worksheet size to say 11 columns and 11 rows. | New Users to Excel | |||
| is there a limit to the number of rows a worksheet can have? | Excel Discussion (Misc queries) | |||
| How do I limit the number of rows displayed on a worksheet? | Excel Discussion (Misc queries) | |||
| Increase rows in worksheet beyond 65,536 row limit | Excel Discussion (Misc queries) | |||
| How do I limit the number of rows in an Excel worksheet. | Excel Worksheet Functions | |||
Linear Mode
