Archive of Mr Excel Message Board


Back to General Excel archive index
Back to archive home

"Out of Memory" message Excel97 - 11meg file

Posted by Tracey Morris on July 03, 2000 1:26 PM
A co-worker has an 11-meg file - 30+ sheets, charts, 3-D formulas etc.
She is starting to get an "out of Memory" error when doing such simple things as formatting text - no other apps are open.

The file is stored on a network drive, and the app is pulled off the network as well.
We've tried working with the file on a couple of Pentium & PEntium II's with 32-64 meg memory - same error.

We've cleared the C:\Windows\Temp file and made sure the formatting is not extending beyond the data.
We're also looking at changing the Zoom to 100%.
The file does have macros - I have not gone into the code to see what is going on there yet.

Any thoughts on what might be causing the problem other than maybe the file size?

Thanks!
Tracey Morris


Re: "Out of Memory" message Excel97 - 11meg file

Posted by david on July 03, 0100 3:00 PM
Try to get rid of as many formulas as you can. If you had formula's to get data now you have the data do a cut and paste value


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.