what is ‘new fonts’ message (Excel 2002, SP2)

Topic

New Reply

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

Reply | Quote

Replies

Check out this MS Article.

Steve

Reply | Quote

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.

Reply | Quote

Great minds think alike!

Steve

Reply | Quote

And post simultaneously

Reply | Quote

And post simultaneously

Reply | Quote

Great minds think alike!

Steve

Reply | Quote

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…. 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.

Thnx, Deb

Reply | Quote

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.

Reply | Quote

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

Steve

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

Reply | Quote

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

Steve

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

Reply | Quote

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.

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.

Thnx, Deb

Reply | Quote

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)?

Reply | Quote

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!!

Thnx, Deb

Reply | Quote

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.

Reply | Quote

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!!

Thnx, Deb

Reply | Quote

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)?

Reply | Quote

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.

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.

Thnx, Deb

Reply | Quote

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.

Reply | Quote

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…. 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.

Thnx, Deb

Reply | Quote