Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Mar 2002
    Location
    Quebec City, Quebec, Canada
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    too many different cell formats (Escel 2002)

    I have put together a rather large workbook, with about 50 sheets, for structural design of buildings. Yesterday, I had the bright idea of adding some colour to improve the readability, and so I formatted many many cells.
    Then I got an error message: "Too many different cell formats", so I guess I reached the limit.
    What's the solution ? I split off several sheets to another file, but the message recurs. Maybe I need to divide the file into several smaller ones.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: too many different cell formats (Escel 2002)

    Yo'll have to simplify the formatting in the workbook, for example reduce the number of custom number formats. See MSKB article You receive a "Too many different cell formats" error message in Excel and the thread starting at <post:=437,998>post 437,998</post:>.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: too many different cell formats (Escel 2002)

    One thing to start with is to save the file as web page and then reload the file and save-as normal Excel workbook. That at least gets rid of the no longer used styles and number formats.

    Make sure you use a different name when you do the save-as, so as not to loose your original...
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    Lounger
    Join Date
    Mar 2002
    Location
    Quebec City, Quebec, Canada
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: too many different cell formats (Escel 2002)

    Thanks Hans and Jan,
    I eliminated a few unused formats using the code in the mentioned thread, and I saved as htm file. I am waiting for it to save as xls at the moment.
    If I still have trouble, I will try to uniformise the formats.

    Thanks a lot.

Posting Permissions

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