Hi Hilarys,
I keep getting the error message saying that no more fonts are allowed. Why
is this happening and is there a way to avoid getting this message?
There is a limit to how many different fonts Excel can handle in a single
workbook and you have reached that limit. Mostly this happens to workbooks with
many charts. If you right click in a chart (so no item of the chart is
selected) and choose "Format Chart Area", then set a font and hit OK, all fonts
inside the chart will become the same. If you repeat that for all charts, your
font usage should drop.
Regards,
Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
