+ Reply to Thread
Results 1 to 5 of 5

The dreaded "no more fonts" error

  1. #1
    Registered User
    Join Date
    01-31-2015
    Location
    Indiana, USA
    MS-Off Ver
    2010 & 2013
    Posts
    3

    The dreaded "no more fonts" error

    I have a workbook that makes use of the Bruin outlook macro that's full of dozens and dozens of hidden sheets, most roughly the same format.

    I have NO charts in this workbook.

    Some users (I distributed this for employees across my company intranet, they all use MSO 2010) receive the "no more fonts may be applied" error upon just opening the workbook, and some work just fine.

    I suppose it's possible that I've exceeded the 4,000 font combination limitation but I highly doubt it. Regardless, I'm currently going through and trying to consolidate font combinations.

    Is there a reason some users would be getting this error while others (including myself) don't? I had the user close all other workbooks before they opened mine and they still got the error.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Seattle, WA, USA
    MS-Off Ver
    MS Office 365 Excel 2016
    Posts
    13,767

    Re: The dreaded "no more fonts" error

    Hi,

    Does this suggestion make sense?
    http://www.excelgeek.co.uk/2013/01/n...this-workbook/
    One test is worth a thousand opinions.
    Click the * below to say thanks.

  3. #3
    Registered User
    Join Date
    01-31-2015
    Location
    Indiana, USA
    MS-Off Ver
    2010 & 2013
    Posts
    3

    Re: The dreaded "no more fonts" error

    Sorry, but as I said I have NO charts in this workbook.

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Seattle, WA, USA
    MS-Off Ver
    MS Office 365 Excel 2016
    Posts
    13,767

    Re: The dreaded "no more fonts" error

    Questions..
    1. Are all users using the same or older versions of Excel?
    2. Are the machines giving errors less memory machines?
    3. Are all fonts installed on the machines giving errors?

    http://support.microsoft.com/kb/837463 or
    http://www.microsoft.com/typography/...zingfonts.mspx

  5. #5
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    39,242

    Re: The dreaded "no more fonts" error

    How about just resetting the whole workbook to style Normal, and then (judiciously) reapplying formatting?
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1