Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maximum Number Of Worksheets In A Work Book-Not A Memory Issue????
Hi there,
I have a worbook that currently has 145 worksheets in it and a file size of 10,094kb. It will not allow me to add more, nor move worksheets from one place to another. I was told this could be cuased by lack of memory, so my IT department has already doubled my memory to 1 GB, but it did not correct the problem. I can still add data to the spreadhseet and save, however I cannot add anymore worksheets. The workbook does have macro's and is linked in multiple places. All functionality has been normal until yesterday. Do you have any ideas.? -- Tickfarmer |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maximum Number Of Worksheets In A Work Book-Not A Memory Issue????
Your system RAM normally has notihing to do with it. XL maintains it's own
memory pool. The size of that pool depends on your version of XL. Look in the task manager to determine how much memory XL is using (this can be very different from the file size) and compare that to the infomration found on this site... http://www.decisionmodels.com/memlimits.htm -- HTH... Jim Thomlinson "Tickfarmer" wrote: Hi there, I have a worbook that currently has 145 worksheets in it and a file size of 10,094kb. It will not allow me to add more, nor move worksheets from one place to another. I was told this could be cuased by lack of memory, so my IT department has already doubled my memory to 1 GB, but it did not correct the problem. I can still add data to the spreadhseet and save, however I cannot add anymore worksheets. The workbook does have macro's and is linked in multiple places. All functionality has been normal until yesterday. Do you have any ideas.? -- Tickfarmer |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maximum Number Of Worksheets In A Work Book-Not A Memory Issue
Thanks for your help.
-- Tickfarmer "Jim Thomlinson" wrote: Your system RAM normally has notihing to do with it. XL maintains it's own memory pool. The size of that pool depends on your version of XL. Look in the task manager to determine how much memory XL is using (this can be very different from the file size) and compare that to the infomration found on this site... http://www.decisionmodels.com/memlimits.htm -- HTH... Jim Thomlinson "Tickfarmer" wrote: Hi there, I have a worbook that currently has 145 worksheets in it and a file size of 10,094kb. It will not allow me to add more, nor move worksheets from one place to another. I was told this could be cuased by lack of memory, so my IT department has already doubled my memory to 1 GB, but it did not correct the problem. I can still add data to the spreadhseet and save, however I cannot add anymore worksheets. The workbook does have macro's and is linked in multiple places. All functionality has been normal until yesterday. Do you have any ideas.? -- Tickfarmer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can the worksheets in a work book be sorted ascending? | Excel Worksheet Functions | |||
How do I print multiple worksheets of a work book onto one page? | Excel Discussion (Misc queries) | |||
Viewing Multi-worksheets in same work-book | Excel Worksheet Functions | |||
formula adding cells in worksheets when # of sheets in work book changes | Excel Discussion (Misc queries) | |||
List of Worksheets in a work book | Excel Worksheet Functions |