MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Memory


Posted by John on September 19, 2001 5:46 AM

I need to open two large excel files however just before the second one finishes I receive an error stating " Not enough Memory" . I have approx 2.2G of virtual memory, any help would be appreciated!


Posted by Eric on September 19, 2001 6:07 AM

Virtual memory is not going to help you much if most of it resides on your hard drive as a swap file- it's actual RAM that you need.
You could try opening the files one at a time, either converting everything you can from formulas to values, or saving only relevant sheets to a new file.

Either way I think the goal is to reduce the number of formulas- this will drastically reduce the memory load.
Hope that helps