Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
15 MB of Heap Space Too Much For Excel?
Starting yesterday, I've been getting a strange message telling me that
"Excel cannot complete the task with the resources available"....through various research, I discovered the Application.MemoryUsed function. I've popped it up at various sections of my code, and it shows that Excel is using between 8,900,000 and 15,229,000 bytes...this latter number, if my calculations are correct, translates to around 14.5 MB. According to the article at http://www.decisionmodels.com/memlimitsc.htm, my version of Excel (XL 2003) should have nearly a gig of space before I get any errors. So what's going on here? -- Hmm...they have the Internet on COMPUTERS now! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
15 MB of Heap Space Too Much For Excel?
It seems a few people have recently come across memory problems for no
apparent reason. Whilst I'm not sure what the 14.5MB actually refers to or how accurate it is, I doubt it is out by a factor of 10. What about pivot tables ? Apart from that, not sure what you can do. NickHK "MDW" wrote in message ... Starting yesterday, I've been getting a strange message telling me that "Excel cannot complete the task with the resources available"....through various research, I discovered the Application.MemoryUsed function. I've popped it up at various sections of my code, and it shows that Excel is using between 8,900,000 and 15,229,000 bytes...this latter number, if my calculations are correct, translates to around 14.5 MB. According to the article at http://www.decisionmodels.com/memlimitsc.htm, my version of Excel (XL 2003) should have nearly a gig of space before I get any errors. So what's going on here? -- Hmm...they have the Internet on COMPUTERS now! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Space removal - a first name,space last name | Excel Discussion (Misc queries) | |||
Excel not seeing the space | Excel Discussion (Misc queries) | |||
formula that will go up one space if no value in specified space | Excel Worksheet Functions | |||
Paper Space / Model Space ? | Excel Discussion (Misc queries) | |||
Having stack/heap memory in Excel VBA | Excel Programming |