Results 1 to 6 of 6

Thread: Excel 2007 to 2003 "Too many different cell formats" error

  1. #1
    Join Date
    Sep 2005
    Posts
    14

    Excel 2007 to 2003 "Too many different cell formats" error

    Whenever i try to open large files saved in Excel 2007 format in Excel 2003 i get an message saying "Too many different cell formats". It comes up for large files only, they open up fine in Excel 2003, i have been looking after a fix for the same but i haven't come across any effective solution yet.

    Can anyone help??

  2. #2
    Join Date
    Sep 2004
    Posts
    73
    Whenever i try to open large files saved in Excel 2007 format in Excel 2003 i get an message saying "Too many different cell formats". It comes up for large files only, they open up fine in Excel 2003, i have been looking after a fix for the same but i haven't come across any effective solution yet.

    Can anyone help??
    Edit/Delete Message
    You can try out the resolution mentioned in below article.....

    You receive a "Too many different cell formats" error message in Excel

    For any queries further you can ask me for help.

  3. #3
    Join Date
    Apr 2009
    Posts
    1

    Re: Excel 2007 to 2003 "Too many different cell formats" error

    Dear All,

    It looks easy to solve this error.Let make a copy sheet or moving sheets into other file. Then delete the original sheet in that workbook. Save original workbook which already deleted file inside into new name file. Then moving back the deleted sheet into the original file using copy or moving file command and save it and close again. Then continue your working. I have tried it and looks work, Thank you.

  4. #4
    Join Date
    Aug 2009
    Posts
    1

    Re: Excel 2007 to 2003 "Too many different cell formats" error

    thanx..
    It really works!!

  5. #5
    Join Date
    Oct 2011
    Posts
    1

    Re: Excel 2007 to 2003 "Too many different cell formats" error

    I didn't really understand what the fix was. I'm a little confused due to the wording. HELP!

  6. #6
    Join Date
    Dec 2007
    Posts
    996

    Re: Excel 2007 to 2003 "Too many different cell formats" error

    Quote Originally Posted by lsreleford View Post
    I didn't really understand what the fix was. I'm a little confused due to the wording. HELP!
    Alternately you can search from google and download a software called Style reduction tool that analyzes and processes Microsoft Excel spreadsheets in order to fix the hardcoded limit of formatting styles per spreadsheet, several thousands. If you use formatting intensively, then you have probably bumped on this blocking "too many different cell formats" error.

Similar Threads

  1. Can not open file "Xlsx" with excel 2007
    By Bassus45 in forum Windows Software
    Replies: 16
    Last Post: 10-02-2012, 06:59 AM
  2. Replies: 5
    Last Post: 31-12-2011, 04:57 PM
  3. Replies: 3
    Last Post: 22-10-2009, 10:03 PM
  4. Excel 2003 "file error: data may have been lost" after applying SP3
    By joshbilsky@gmail.com in forum Office Update Service
    Replies: 1
    Last Post: 09-11-2007, 03:49 AM
  5. Replies: 2
    Last Post: 17-01-2007, 08:47 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
  •