If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
No more new fonts may be applied to this workbook
Hello,
I have an Excel Workbook with 6 worksheet containing a variety of charts linked to data sources in different workbooks. I receive the error message "No more new fonts may be applied to this workbook" when any font changes are attemped in the charts. I have tried the suggestion on the MS knowledge base (uncheck autoscale selection) with no success. I only receive the same error message. I am running Excel 2002. Any suggestions? Thanks for any help provided :-) |
#2
|
|||
|
|||
No more new fonts may be applied to this workbook
Could you get by with fewer charts? Split them over multiple workbooks,
perhaps, or use dynamic charts that show what is selected in a dropdown box. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ wrote: Hello, I have an Excel Workbook with 6 worksheet containing a variety of charts linked to data sources in different workbooks. I receive the error message "No more new fonts may be applied to this workbook" when any font changes are attemped in the charts. I have tried the suggestion on the MS knowledge base (uncheck autoscale selection) with no success. I only receive the same error message. I am running Excel 2002. Any suggestions? Thanks for any help provided :-) |
#3
|
|||
|
|||
No more new fonts may be applied to this workbook
This web page has some macros that disable font autoscaling:
http://www.geocities.com/jonpeltier/.../FixFonts.html - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ ola wrote: It's an Excel limitation. You can get around it for many size projects by using the solution below. Note that you may need to copy a worksheet out to another book temporarily in order to eliminate the error message long enough to go into each graph and de-select the auto-scale option. Then you'll have to scale the fonts in each chart. It's time consuming, but does the trick. http://pubs.logicalexpressions.com/P...?ID=209#jon025 |
Thread Tools | |
Display Modes | |
|
|