ExcelBanter - View Single Post

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