Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



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

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 29-08-2007
Member
 
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??

Reply With Quote
  #2  
Old 30-08-2007
Member
 
Join Date: Sep 2004
Posts: 73
Quote:
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.
Reply With Quote
  #3  
Old 28-04-2009
Member
 
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.
Reply With Quote
  #4  
Old 12-08-2009
Member
 
Join Date: Aug 2009
Posts: 1
Re: Excel 2007 to 2003 "Too many different cell formats" error

thanx..
It really works!!
Reply With Quote
  #5  
Old 14-10-2011
Member
 
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!
Reply With Quote
  #6  
Old 14-10-2011
Member
 
Join Date: Dec 2007
Posts: 994
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.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Excel 2007 to 2003 "Too many different cell formats" error"
Thread Thread Starter Forum Replies Last Post
Can not open file "Xlsx" with excel 2007 Bassus45 Windows Software 16 10-02-2012 07:59 AM
VBA Error "This workbook has lost its VBA project" in Excel 2003 Avvy Windows Software 5 31-12-2011 05:57 PM
Excel 2007 error "Clipart cannot complete the operation" teenQ Windows Software 3 22-10-2009 11:03 PM
Excel 2003 "file error: data may have been lost" after applying SP3 joshbilsky@gmail.com Office Update Service 1 09-11-2007 04:49 AM
Project Web Access via IE7: "Export Grid to Excel" cause VBSCRIPT (error) message: "The activeX control on which this feature depends could not be created" Theo-Dore Microsoft Project 2 17-01-2007 09:47 PM


All times are GMT +5.5. The time now is 04:18 PM.