Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Error message: no new fonts
I have created a workbook which tracks lab data for a number of facilities.
Sheet 1 holds all of my data, and Sheet 2 produces a report for each facility. The report for each facility is one page in length and contains a table of the data, plus two charts. There are about 300 facilities that I have strung together on this worksheet. However, when I go to edit any of the data or charts, I receive a message, "No more new fonts may be applied in this workbook". My only option is to select "OK". When I select "OK", the box continues to pop back up until the entire program is frozen. Is there any way to fix this problem? |
#2
|
|||
|
|||
You should try to rearrange your report so you have many fewer charts per worksheet.
Many of Excel's limitations are legacies of the DOS/Win3.1 days, when a system had limited resources. Using this scheme, a chart needs its own font resources, even though all the charts might use the same font face and size, and a sheet has a limit of something like 256 font resources. Archaic stuff. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ SJC wrote: I have created a workbook which tracks lab data for a number of facilities. Sheet 1 holds all of my data, and Sheet 2 produces a report for each facility. The report for each facility is one page in length and contains a table of the data, plus two charts. There are about 300 facilities that I have strung together on this worksheet. However, when I go to edit any of the data or charts, I receive a message, "No more new fonts may be applied in this workbook". My only option is to select "OK". When I select "OK", the box continues to pop back up until the entire program is frozen. Is there any way to fix this problem? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fonts not displaying correctly | Excel Discussion (Misc queries) | |||
Error Message - No more new fonts may be applied to this workbook | Excel Discussion (Misc queries) | |||
FONTS | Excel Discussion (Misc queries) | |||
Excel 2000 crashes when changing fonts. | Excel Discussion (Misc queries) | |||
Copying spreadsheet with fonts and patterns | Excel Discussion (Misc queries) |