What happens with "font resources" is that Excel needs one font resource
per chart, or two if you have font autoscaling enabled. (So I guess
parts of Excel are still living in DOS.)

The VBA and Registry procedures described on this page turn off font
autoscaling, which supposedly doubles the number of charts you can have
without getting that annoying memory error.

http://peltiertech.com/Excel/Charts/FixFonts.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

redbelly wrote:

wrote:

Hi -

You're probably running into internal resource limitations in Excel.
How complex is your source and target workbook? If you've got

multiple

charts in both you're going to run into the infamous 256 font
limitation (if you have more than 256 font combinations, Excel runs

out

of resources...)

John


Wow, thanks! I've had the same problem, and wondered about it. I
guess by "font combination", you mean any combination of font, text
size, color, bold/italic/underline, and other richtext options.

Does anybody know if a large number of font combinations would also
cause the size of an Excel file to grow, inexplicably, to many times
what it "should" be? This is another problem I've had, and it seems to
happen in files of mine with many (around 30 or so) charts.

Thanks,

Mark