Ask a Question Sign up for Free 103 Experts currently online. Ask Questions for Free!

Too Many different cell formats - Excel Troubleshooting

Is there any way to open an Excel file, when all it does is display the "Too many different cell formats message?"...

Results 1 to 20 of 21

  1. #1

    Too Many different cell formats

    Is there any way to open an Excel file, when all it does
    is display the "Too many different cell formats message?"
    MCTOM
  2. #2

    Too Many different cell formats

    Try this...

    http://support.microsoft.com/default.aspx?scid=KB;en-
    us;213904&



     
    none
  3. #3

    Too Many different cell formats

    I read the Knowledge Base article, but the problem is, the
    file does not open at all after it displays the message.
     
  4. #4

    Too Many different cell formats

    try this:

    hit START...go to RUN...type EXCEL /s or
    Excel /safe ...when excel opens go up to FILE to OPEN,
    browse to this file and see if that helps. Worth a try.
    It may open and then you can make some changes per the KB
    article??

    Let me know.


     
    the 
    does 
    message?" 
    none
  5. #5

    Too many different cell formats

    I rec'd this error message on a large Excel file that I
    am creating. I have been able to reduce the number of
    formats and I am able to work on the file, however my
    question is:

    Is there a way to count the number of "formats" in a
    specific file to determine how close you are to the 4,000
    level.

    Thanks, csb
    csb
  6. #6

    Re: Too many different cell formats

    Hi csb,

    Unfortunately I do not think there is a way of counting formats.


    Charles
    ______________________
    Decision Models
    FastExcel Version 2
    www.DecisionModels.com

    "csb" <microsoft.com> wrote in message
    news:127201c3a86f$d3ffaa90$gbl... 


    Charles
  7. #7

    too many different cell formats

    I have file which I, when I try an open it, just gives me
    the message "Too many different cell formats", and then
    won't open.

    Does anyone know how to get around this.?


    neil
  8. #8

    Too many different cell formats

    I get an "Too many different cell formats." error message when trying to change certian cells and when updating certian pivot tables. Closing the workbook and re-starting fixes the problem some of the time.
    Phred
  9. #9

    Too Many Different Cell Formats

    I have a file with about 15 spreadsheets that involve many formats. I have received the error message "Too many different cell formats". However, I don't believe that I have exceeded the limit of 4,000. In addition, I have been prevented from making other changes to the file, such as inserting a row (which does not add to the number of new cell formats). Plus, If I delete a worksheet, save the file and then try to add another cell format in one of the remaining spreadsheets, I am still prevented from applying the new format. Any advice on this condition?
    Boak
  10. #10

    Re: Too Many Different Cell Formats

    Boak wrote.. 
    have received the error message "Too many different cell formats". However,
    I don't believe that I have exceeded the limit of 4,000. In addition, I
    have been prevented from making other changes to the file, such as inserting
    a row (which does not add to the number of new cell formats). Plus, If I
    delete a worksheet, save the file and then try to add another cell format in
    one of the remaining spreadsheets, I am still prevented from applying the
    new format. Any advice on this condition?<<<

    Boak,

    You might not have 4000 defined cell formats, but you have more that 4000
    cells that have unique formats?

    I encourage you to look at this post: http://tinyurl.com/3eyqp

    Look at Dave Paterson's comments with respect to Open Office and fixing bit
    by bit.

    I trust you already saw this kb:
    http://support.microsoft.com/default.aspx?scid=kb;en-us;213904

    So if I were to provide a suggestion, it would be to open your doent and
    start applying consistent formatting to various sections. I suspect that as
    you begin applying a consistent format, your problem disappears.

    Perhaps you copied and pasted stuff from the web to your doent? That
    always provides a plethora of formats.

    Hope that helps.

    Best regards,
    Kevin


    Kevin
  11. #11

    TOO MANY DIFFERENT CELL FORMATS

    I have a very large spreadsheet with about 35 worksheets
    approx 20,000kb in size - all of a sudden I am receiving
    the following message when i try to change the format of a
    cell "TOO MANY DIFFERENT CELL FORMATS" - what can I do
    to get my cell formatting functions back???? Any
    suggestions?
    Rose
  12. #12

    re: TOO MANY DIFFERENT CELL FORMATS

    excel does not too much formatting. After all, it is a
    spread sheet and not a doent. You will have to remove
    some of the more fancy stuff like fancy border and
    backgrounds, remove the borders around all the cells that
    are not printed, and if old formats are no longer seen,
    exterminate them. Keep formatting to a minimum.
    Preferably, only to areas that are printed or seen by
    other people other than yourself.

    regards
    mark
     

    Mark
  13. #13

    TOO MANY DIFFERENT CELL FORMATS

    If you want to keep your lay-out, then cut your sheet in
    different pieces and link them where necesary. It will
    speed up your performance for sure!
    Adri
  14. #14

    Too Many Different Cell Formats

    I have a large Excel workbook (8,047 KB) that worked fine until today.

    When I now attempt to open the file, I now get the error message "Too Many
    Different Cell Formats" and must click on "OK". The file will not open.
    HELP!!

    Danj
  15. #15

    too many different cell formats

    In Excell I get a message stating Too many different cell formats.
    Can I increase the amount of cell formats for the spreadsheet or can I get
    around this problem
    Stephen
  16. #16

    Re: too many different cell formats

    Hi Stephen,
     

    You cannot get around this other than by simplifying the sheet's formatting.

    Tip: formatting an entire row or column consumes less resources than
    formatting part of the row/column.

    Regards,

    Jan Karel Pieterse
    Excel MVP
    www.jkp-ads.com

    Jan
  17. #17

    Too many different cell formats

    I am trying to use the hide formula function. But I keep getting the "Too
    many different cell formats" error. I can't get past this and need help in
    correcting the problem.
    Marcor@earthlink.net
  18. #18

    Re: Too many different cell formats

    Marcor

    The error is exactly what it says. Too many cell formats. Excel counts
    cell formats as unique if anything is different, font, colour, alignment,
    wrap, etc, etc. The limit is quite small too. To correct this I suggest you
    set up a few styles, (format>styles...) and use these. That way you can be
    sure that all formats that look the same, are.

    --
    HTH
    Nick Hodge
    Microsoft MVP - Excel
    Southampton, England
    co.uk.ANDTHIS


    "net" <microsoft.com>
    wrote in message news:com... 


    Nick
  19. #19

    RE: Too Many Different Cell Formats

    Did you get sorted? I have the same problem!
    I just cannot the file in the first place.

    "Danj" wrote:
     
    Richard
  20. #20

    too many different cell formats

    What does the error message 'too many different cell formats' mean in excel?
    I cannot open a spreadsheet that was sent to me by a Java interface from an
    iSeries.
    Valley
Page 1 of 2 12 Last
  • Jump to page:

Similar Threads

  1. "Too Many Different Cell Formats"
    By Ed in forum Excel Troubleshooting
    Replies: 2
    Last Post: 09-23, 07:10 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100