+ 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
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    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 * Add Reputation 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
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    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 Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    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)

Similar Threads

  1. [SOLVED] Eliminating that dreaded "#num!" from a variable list
    By khank in forum Excel General
    Replies: 2
    Last Post: 09-23-2012, 10:47 AM
  2. The dreaded "Cannot run the macro..." message...any ideas?
    By Fiddlerky in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-30-2010, 06:46 PM
  3. re: error message "NO more new fonts may be applied" ?
    By Mark in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-01-2006, 12:15 PM
  4. Replies: 3
    Last Post: 02-17-2006, 12:30 AM
  5. [SOLVED] What is the error message "No more fonts available in worksheet?"
    By Cyclone Marc in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-07-2005, 12:10 AM

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