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.
Allison Andrews wrote: > 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.
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?
Allison Andrews wrote: > 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.
> 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.
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.vandewee...@ping.be
kschuste heeft geschreven in bericht <3650EA89.89CAE...@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?
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.
Allison Andrews wrote in message <36489AD3.1FF48...@epi.epson.com>... >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.
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.
Wim Vandeweerdt wrote in message <72i8oa$su...@news3.Belgium.EU.net>... >I have the same problem, but no solution. >Can it be a virus? >I am very interested... and nearly crazy. >wim.vandewee...@ping.be
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? On Tue, 24 Nov 1998 12:41:00 -0500, "Ya Chen"
<yac...@acsu.buffalol.edu> wrote: >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$su...@news3.Belgium.EU.net>... >>I have the same problem, but no solution. >>Can it be a virus? >>I am very interested... and nearly crazy. >>wim.vandewee...@ping.be
