Running out of Memory????

177 views
Skip to first unread message

Jim

unread,
Apr 20, 2001, 7:52:45 AM4/20/01
to
I have a workbook that is current 23-24MB in size. My computer is a
P3-600E with 256MB of RAM. After opening this workbook it runs fine
until I either try to create another worksheet or open another
workbook. I get the message "out of memory." I have to close Excel
or weird things begin to happen. Originally this occured while using
my laptop with 128MB of ram, so I changed to my desktop with 256MB of
RAM thinking it would fix the "out of memory" problem but it did not.

Is there a limiting factor given the amount of memory that your
computer has in relation to Excel? Or is this a limitation of Excel
itself? Any help would be appreciated.

Thanks,

Jim Qualizza

Charles Williams

unread,
Apr 20, 2001, 10:11:09 AM4/20/01
to
Hi Jim,

Not sure exactly which limit you are hitting, but Excel has a memory manager
that imposes its own limits regardless of the amount of RAM you have.

For Excel 97 and 2000 there are memory limits on various items. These limits
operate relatively independently of each other. (The following list is far
from complete)

Formulae, Pivot Tables and UNDO: about 80MB
This has been increased to approx 160 MB in Excel2002.
Cells containing data: limit not yet found: >200MB
External links: see MSKB articles 16375 unique cells per Worksheet in a
closed Workbook, 16000 cells in a single reference
(MSKB Articles) Charts, more Charts, Graphic objects, and Zoom seem to have
a relatively low limit.

These limits mainly apply at the Application level, and so are cumulative
across all the open Workbooks, although you can open two instances of Excel
and each instance will have these limits independently of the other.

Because the limits are more or less independent a Workbook containing both
data and formulae can use more than 80 MB.

HTH
Charles
"Jim" <qual...@earthlink.net> wrote in message
news:kh80ets6148v27ehs...@4ax.com...

Tom Ogilvy

unread,
Apr 20, 2001, 10:35:49 AM4/20/01
to
Make sure your zoom (view=>Zoom) is set to 100%. Just one other thing to
check.

Regards,
Tom Ogilvy

"Jim" <qual...@earthlink.net> wrote in message
news:kh80ets6148v27ehs...@4ax.com...

Jim

unread,
Apr 20, 2001, 6:42:43 PM4/20/01
to
On Fri, 20 Apr 2001 15:11:09 +0100, "Charles Williams"
<Cha...@DecisionModels.com> wrote:

Thanks for the reply. I am using Excel 2000 and I used VBA to
provide me with the current memory information after opening the large
workbook I have talked about earlier. Here it is...

Memory Used = 44,763,324
Memory Free = 1,048,576
Total Memory = 45,811,900

The exact file size of the workbook is 24,276,480. This seems to
explain why I am running out of memory when I try to open another
large workbook or when I try to create another worksheet within this
workbook. But from what you have stated I should have access to 80MB?
This workbook does not contain any charts it is mostly data and
formulas, more formulas than anything else.

Tom, I checked the view and it is at 100%.

Thanks,

JIM

Charles Williams

unread,
Apr 20, 2001, 7:51:45 PM4/20/01
to
Jim,
The memory free number is misleading: it always gives approximately the same
number.
Surprising that you cannot add another ?empty? worksheet: I dont know why.
regds
Charles

"Jim" <qual...@earthlink.net> wrote in message

news:jbe1etoikbilv76e6...@4ax.com...

KenMcDaniel

unread,
Apr 23, 2001, 4:06:53 PM4/23/01
to
Does the workbook have a lot of graph's? If so, turn off Auto Scaling on the
format chart font tab. See KB Q168650.

Thanks,

JIM

.

Reply all
Reply to author
Forward
0 new messages