+ Reply to Thread
Results 1 to 5 of 5

counting format variations

  1. #1
    Registered User
    Join Date
    05-24-2012
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    2

    counting format variations

    I have just received the error message telling me I've too many formats (believe the limit is 4000) and the workbook has frozen. To help me identify where the problem lies (within the 35 worksheets in my workbook) is there anything that can tell me how many formats each worksheet has used?

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: counting format variations

    Hi tonyfrier,

    Welcome to the forum.

    See a post in Microsoft about his :-

    http://support.microsoft.com/kb/213904

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

  3. #3
    Registered User
    Join Date
    05-24-2012
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: counting format variations

    Thanks - that's a useful article but doesn't cover finding where all the offending formatting lies. I don't want to use the clean-up tool becuase I do want some formatting in the workbook.

  4. #4
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,448

    Re: counting format variations

    I don't think some formatting is more offending than others.
    Make a copy of your book and remove the less necessary formatting and see if it helps.

    Perhaps Rule 3 of this whitepaper will guide you
    Be very, very careful using IFERROR ! It hides ALL errors which is not always what you want to get correct results

  5. #5
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: counting format variations

    I don't want to use the clean-up tool
    why not? once run you can then format there is also this one
    http://www.microsoft.com/en-us/downl....aspx?id=21649
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ 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