Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
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 |