Results 1 to 12 of 12
  1. #1
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    what is 'new fonts' message (Excel 2002, SP2)

    I'm moving sheets from one workbook to another workbook and get the message "no more new fonts may be applied to this workbook." I'm doing this manually from the sheet tabs and after moving several sheets, I got this message. I have to click OK many, many times before it goes away. I assume it's because the source workbook has some set of fonts and those are getting added to the fonts in the destination workbook?

    What does this mean and how do I get rid of it? How do I remove unneeded fonts? Someone else created these two workbooks so I've never seen this message in projects I've done.

    Thnx, Deb <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: what is 'new fonts' message (Excel 2002, SP2)

    Check out this MS Article.

    Steve

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: what is 'new fonts' message (Excel 2002, SP2)

    Each tine you copy a chart, you add fonts to those in memory, unless all charts contain the same fonts in the same sizes. There is an MSKB article for Excel 2000 about this error: XL2000: Error Copying Worksheets Containing Charts. It contains two workarounds.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: what is 'new fonts' message (Excel 2002, SP2)

    Great minds think alike!

    Steve

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: what is 'new fonts' message (Excel 2002, SP2)

    And post simultaneously <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>

  6. #6
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: what is 'new fonts' message (Excel 2002, SP2)

    Wow, that was a quick reply!! I've already moved all the sheets and have hit the OK button a million times to get rid of the error message. Since the error is caused by too many charts (which this workbook has) I'll turn off auto-scaling as it says. But on the other hand, since I already moved all the sheets, I wonder if I have to do this at all? Did my moving the sheets (and ignoring the error message) mess up anything? I wonder.... <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16> I'm not the author of this workbook so can't say for sure if fonts changed (for the worse that is).

    I did search the MS KB but couldn't find any reference to this. I rarely have any luck finding anything in the KB but somehow you guys know the tricks. <img src=/S/clever.gif border=0 alt=clever width=15 height=15>

    Thnx, Deb <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: what is 'new fonts' message (Excel 2002, SP2)

    I haven't encountered this error myself, so I'm not sure. But it might be a good idea to turn off Auto-Scale in all charts to prevent future problems. It shouldn't be too hard to write a macro to do this.

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: what is 'new fonts' message (Excel 2002, SP2)

    This should check all sheets for chart objects and change them or if the sheet is a chartsheet change it.

    Steve

    <pre>Option Explicit
    Sub AutoScaleOffAllCharts()
    Dim sht
    Dim chtobj As ChartObject

    For Each sht In Sheets
    If sht.Type = 3 Then _
    sht.ChartArea.AutoScaleFont = False
    For Each chtobj In sht.ChartObjects
    chtobj.Chart.ChartArea.AutoScaleFont = False
    Next
    Next
    End Sub</pre>


  9. #9
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: what is 'new fonts' message (Excel 2002, SP2)

    An update... I started over and removed auto-scale from all charts. I then proceeded to move the worksheets from workbook A into workbook B but I still got the same error message about too many fonts. So auto-scale didn't do a darn thing after all. <img src=/S/crybaby.gif border=0 alt=crybaby width=15 height=15>

    I didn't check if the font type and size were the same on all charts but I'll try this next. If I can't get both workbooks into one, then this tool will be quite cumbersome for the user (having to switch back/forth). I'll have to create a 3rd workbook which switches between the two workbooks based on the user's log-in info (since access to one of them is restricted by password). Distributing more than one workbook is a pain because there's more chance of the user losing one of the workbooks.

    Ah, well,... yet another Excel-ism to add to my collection. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

    Thnx, Deb

  10. #10
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: what is 'new fonts' message (Excel 2002, SP2)

    What happens when you move all sheets in one go (select them first whilst holding control or shift, then drag them over to the other book)?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  11. #11
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: what is 'new fonts' message (Excel 2002, SP2)

    The same error occurs. I ended up going through all charts yet again and setting their font size to the same and that was enough to get rid of the error (also turned off auto-scale). The combined file is now over 2MB.

    I wouldn't of been able to figure this out with Woody's Lounge!! <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23> <img src=/S/bow.gif border=0 alt=bow width=15 height=15>

    Thnx, Deb

  12. #12
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Long Beach, California, USA
    Posts
    233
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: what is 'new fonts' message (Excel 2002, SP2)

    One of my office mates just ran into this issue. As per the MS KB article 215573, we created a new key in the registry to disable the Auto scale setting and ran the VBA code given in the article to programmatically disable Auto scale on all existing charts in the workbook yet still received the error message.

    I Googled the error string and found several references to "charts with titles". I had her go through her workbook and remove all titles from her 50 or so charts and the problem is now gone.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •