"Not Enough Memory" errors continue

[Allison Andrews]

I posted this question once before, but unfortunately none of the fixes
Microsoft Support Online has offered seem to work:

I have a half dozen or so people at my company who are getting
continuous "Not enough memory" errors in Excel 97 workbooks that contain
charts. Their PC setup is fine, and the problem moves with the file. I
have tried it on both 95 and NT 4.0, both network and hard drive
installs, have checked virtual memory, and have upgraded to SR-2 (the
new release), it makes no difference:

Microsoft Support suggested the following fixes, none of which have
worked:

1. CTRL-ALT-F9
2. Upgrade to SR-2 and set the
"HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Excel\Microsoft Excel"
AutoChartFontScaling key to 0.
3. Turn off "Auto Scaling" (Usually can't do this, causes another
"not enough memory" error).
4. Make sure the number of charts is less than 124. In all cases,
the number of charts in these files is between 20 and 60.
5. Make sure the number of lines of data 37,120. It is, by far.
These files aren't really that large.

These people are getting more frustrated, and I don't blame them, these
errors are driving me crazy! As I said, the problem has occurred on
every PC these files are opened on, some with lots of memory and drive
space, and even on NT 4.0.

Any suggestions?
Allison Andrews

[Andrew Baker]

Allison,

Don't know if they have cc:Mail as well but we had these same kind of memory
messages and upgrading cc:Mail to the latest release made them go away.

Regards,

Andy (ô¿ô)

Allison Andrews wrote:

--
Regards,

Andy (ô¿ô)

http://home.earthlink.net/~allshookup/

[Wim Vandeweerdt]

I have the same problem, but no solution.
Can it be a virus?
I am very interested... and nearly crazy.
wim.van...@ping.be

[kschuste]

I have a customer who can print as many graphics, word files, etc. but when
runs a macro, that calculates salary for a quarter, more than 3 times it
says "not enough memory to print" or "out of memory". Then gives an error
at a certain line in the macro. Any clues as to what is going on?

[Chip Pearson]

kschuste wrote in message
<3650EA89...@MICROTECHCOMPUTERS.COM>...

> I have a customer who can print as many graphics, word files, etc.
but when
>runs a macro, that calculates salary for a quarter, more than 3 times
it
>says "not enough memory to print" or "out of memory". Then gives an
error
>at a certain line in the macro. Any clues as to what is going on?
>

I would think that posting the code would be the first place to start.
Include ALL DETAILS.

Cordially,
Chip Pearson
http://home.gvi.net/~cpearson/excel.htm

[Wim Vandeweerdt]

The message "Not enough memory to print" is not the same as "Not enough
memory" but I think your printer hasn't got enough memory. If you can't
expand it, you'll maybe buy another printer.
wim.van...@ping.be

kschuste heeft geschreven in bericht

[mark]

Hi Allison,

Possible workaround:
(Step 1) Build each chart in its own separate workbook
(Step 2) Merge all of the charts into a single workbook

I have only tried Step 1 of this solution because of the circumstances of my
own "Not enough memory" problems. I was creating many, many charts in one
workbook, then moving each to a separate workbook. After moving each chart,
the original was visibly gone. Once the "Not enough memory" error hit (after
about 30 charts), I had to reboot Windows NT (complete reboot and not just a
re-login) to create any more charts.

To fix my problem, I created each chart in its own workbook. For your case,
I think performing both steps would work, even though I admit this is not an
elegant solution. I also admit that I am only speculating on step 2.

My theory: The Excel developers hardcoded a memory limit in the Excel "new
chart" code (mistake #1), and are also forgetting to perform garbage
collection so that limit gets exceeded (mistake #2). We are NOT talking
about your computer's available RAM, since the Task Manager says that is
barely affected. So, to never exceed this hidden limit, only create one
chart, or a few charts, in any particular workbook (if the theory is
correct).

Hopefully, once the charts are created you can copy them together.

Good luck
Mark Mitchell

Allison Andrews wrote in message <36489AD3...@epi.epson.com>...

[Ya Chen]

When I open some huge worksheets(3MB each) in the same Excel instance, I
have the same problem.
It also happens when I make charts that have more than 2^20 data points. I
guess that one drawback
of Excel itself, not a bug. Those people in MS may not ever think of
handling huge data sets.

Ya Chen

Wim Vandeweerdt wrote in message <72i8oa$suc$1...@news3.Belgium.EU.net>...

[mel...@bloxpamihug.co.nz]

Unfortunately the original message isn't available to me, but I'm
getting an Insufficient memory when I try to print...was this the
problem?
Mine is with a Version7 file of about 1.5MB and seems to have crept in
with quite a lot of conditional formating. When I save as Version5, no
problem. (Not such a 'nice' spreadsheet tho)
I cut back some of the conditional formating and also some Data
Validation menus and it now prints, unless I have activated a macro.
(any 1 of several) I then have to save the file, close it, reopen it
and it prints.
Any help?

Mick Elmes
http://www.engineer.co.nz