Home |
Search |
Today's Posts |
#1
|
|||
|
|||
fix for worksheet limitation
Excel 97
I have a simple worksheet which tracks my daily time to a job number. This file is suppose to contain 52 worksheets (one created per week). The Problem: I've reached week 26 and cannot copy/create a new worksheet beyond 26. The limit is 255. I been looking for obivous setting oversights but I am out of ideas. Any help is greatly appreciated. TIA |
#2
|
|||
|
|||
Hi Tony
Sounds like you have run out of RAM. Yo'll have to increase it "Tony" wrote: Excel 97 I have a simple worksheet which tracks my daily time to a job number. This file is suppose to contain 52 worksheets (one created per week). The Problem: I've reached week 26 and cannot copy/create a new worksheet beyond 26. The limit is 255. I been looking for obivous setting oversights but I am out of ideas. Any help is greatly appreciated. TIA |
#3
|
|||
|
|||
I run NT w/191MB RAM
rebooted the computer started excel 97 only opened my file which is only 214K tried again to copy the worksheet-clicked create a copy-move to end- will not copy worksheet checking memory usage: 112890K / 703020K (assuming used vs. unused) I think I have enough available memory Any other ideas? "Kassie" wrote: Hi Tony Sounds like you have run out of RAM. Yo'll have to increase it "Tony" wrote: Excel 97 I have a simple worksheet which tracks my daily time to a job number. This file is suppose to contain 52 worksheets (one created per week). The Problem: I've reached week 26 and cannot copy/create a new worksheet beyond 26. The limit is 255. I been looking for obivous setting oversights but I am out of ideas. Any help is greatly appreciated. TIA |
#4
|
|||
|
|||
Hi Tony
Normally, when you cannot add sheets, it is a RAM issue. Do not know the effect of NT though. Also I don't know a lot about 97. I am sure one of the other guys will have a solution though! "Tony" wrote: I run NT w/191MB RAM rebooted the computer started excel 97 only opened my file which is only 214K tried again to copy the worksheet-clicked create a copy-move to end- will not copy worksheet checking memory usage: 112890K / 703020K (assuming used vs. unused) I think I have enough available memory Any other ideas? "Kassie" wrote: Hi Tony Sounds like you have run out of RAM. Yo'll have to increase it "Tony" wrote: Excel 97 I have a simple worksheet which tracks my daily time to a job number. This file is suppose to contain 52 worksheets (one created per week). The Problem: I've reached week 26 and cannot copy/create a new worksheet beyond 26. The limit is 255. I been looking for obivous setting oversights but I am out of ideas. Any help is greatly appreciated. TIA |
#5
|
|||
|
|||
"Kassie" wrote: Hi Tony Normally, when you cannot add sheets, it is a RAM issue. Do not know the effect of NT though. Also I don't know a lot about 97. I am sure one of the other guys will have a solution though! [snip] Hi Kassie, Thanks again for your response. I think the file was corrupted. I fixed the problem by saving the file as an earlier version, 95 to be exact and changing the name. Once I did this, I tested the copy and it worked. I then saved it back to a 97 format and have had no problems. Fortunately there are no formatting issues since the formulas contained in the document are straigth forward and no special formatting was involved. Tony |
#6
|
|||
|
|||
Hi Tony
Glad you sorted it ! "Tony" wrote: "Kassie" wrote: Hi Tony Normally, when you cannot add sheets, it is a RAM issue. Do not know the effect of NT though. Also I don't know a lot about 97. I am sure one of the other guys will have a solution though! [snip] Hi Kassie, Thanks again for your response. I think the file was corrupted. I fixed the problem by saving the file as an earlier version, 95 to be exact and changing the name. Once I did this, I tested the copy and it worked. I then saved it back to a 97 format and have had no problems. Fortunately there are no formatting issues since the formulas contained in the document are straigth forward and no special formatting was involved. Tony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Workaround for Cell Display Limitation in Excel 2000 | Excel Discussion (Misc queries) | |||
pivot table limitation | Excel Discussion (Misc queries) | |||
Function limitation | Excel Worksheet Functions | |||
A version of excel that doesn't have 15 limitation | Excel Worksheet Functions | |||
excel workbook limitation | Excel Discussion (Misc queries) |