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 |
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 |
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 |
All times are GMT +1. The time now is 01:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com