+ Reply to Thread
Results 1 to 5 of 5

Help wanted

  1. #1
    Registered User
    Join Date
    03-18-2008
    Posts
    3

    Exclamation Help wanted

    When I try to create a graph I get a message "No more new fonts may be applied to this workbook". What is this about and how do I get rid of it. A new spreadsheet is not desirable.
    Thanks in anticipation.

  2. #2
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    john6974

    Welcome to excelforum

    Please read forum rules (rule 1) & use suitable thread titles

    A thread with the rules is available at the top of each forum or see link below for rules
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.

  3. #3
    Forum Contributor
    Join Date
    10-27-2006
    Location
    United Kingdom
    MS-Off Ver
    EXCEL 2003 (2007 at home)
    Posts
    517

    I don't know, but...

    The error message gives the impression of an internal limit being reached.

    Is this a very complex spread-sheet containing a large number of different fonts all over the place?
    If so have you tried reducing the overall number of fonts you use?

    Are you using a "user defined" chart type?
    If so does this chart type involve an unusually large number of different fonts?
    Can you get the "standard" chart types to work?

    Mark.

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello john6974,

    Have a look at this Microsoft support atricle on the causes of this error and how to correct it. Also redo your title per the Forum Rules.

    Too many different cell formats error

    Sincerely,
    Leith Ross

  5. #5
    Registered User
    Join Date
    03-18-2008
    Posts
    3

    Smile Font problem

    Problem has been sorted by itself it would seem. I've made no alterations but it is working fine now. Strange.
    Thanks for your help and sorry for thread title. I do not know how to change the title name on original.
    John

+ 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