ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2003 memory issue (https://www.excelbanter.com/excel-discussion-misc-queries/90762-excel-2003-memory-issue.html)

ngenear11

Excel 2003 memory issue
 

The error message that I get is "Excel cannot complete this task with
available resources. Choose less data or close other applications."

I am currently using excel 2003 sp2 and I have 2gb of ram running on
win xp pro. When I use the Info(memused) function it gives 55,150,480
and the Info(memavail)function gives 1,048576. I get this message when
I attempt to insert another sheet into the workbook. After hours of
reading I still cannot solve the problem and it seems that it is a
memory issue. From what I have read excel 2003 should use 1gb of
memory. I cant figure out why my excel is only using appx 55 Mb.
Any help would be greatly appreciated


--
ngenear11
------------------------------------------------------------------------
ngenear11's Profile: http://www.excelforum.com/member.php...o&userid=34844
View this thread: http://www.excelforum.com/showthread...hreadid=545897



All times are GMT +1. The time now is 06:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com