Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2010
    Location
    L.A.
    Posts
    10
    Thanks
    2
    Thanked 0 Times in 0 Posts
    I made a rather large Excel worksheet of my home mortgage payment schedule.
    It is one of many worksheets in a rather large spreadsheet.
    When I try to increase the number of decimal places above 6 in a cell formatted for Number, I get a pop-up dialogue box with this error message.
    Saving and reopening does not work.
    Pasting Special "Formats" only from an empty cell does not work.
    Does anyone know why and/or know a work around?

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Quote Originally Posted by j rice View Post
    I made a rather large Excel worksheet of my home mortgage payment schedule.
    It is one of many worksheets in a rather large spreadsheet.
    When I try to increase the number of decimal places above 6 in a cell formatted for Number, I get a pop-up dialogue box with this error message.
    Saving and reopening does not work.
    Pasting Special "Formats" only from an empty cell does not work.
    Does anyone know why and/or know a work around?
    Looks like you have bumped into Excel 4000 Limit of format combinations in a workbook.
    Or it could have just got some sort of corruption.

    I think that if say you had 20 Cells with Bold then that would be one combination.
    If 5 of these had currency, then that would be 2
    If One of these is Underlined that would be 3
    If 6 of them are Red that would be 4 or more depending upon how the combinations overlap etc.
    So either you've hit this limit or something else has gone wrong.
    I think this limit is in Excel 2003, not sure what it is in 2007.

    Or I might be totally wrong.


    Andrew

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Andrew is correct.
    The only way to overcome this problem is by rationalising your formatting. See this article for one way I recommend:
    www.jkp-ads.com/articles/styles00.asp
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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