If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel 2007 to 2003 "Too many different cell formats" error
I was wondering if anyone else has seen this problem...
When comparing documents from Excel 2007 to Excel 2003 with the compatability pack installed we have an issue where some of our larger documents when opened/saved from 2007 version cannot be opened by the 2003 version, and recieve the "Too many different cell formats". This happens irregardless if the 2007 users saved in the new format or left the document in compatability mode. Prior to 2007 these documents appeared to work correctly. I found the following KB article from Microsoft, but would rather not have to "fix" the formating in the documents. If anyone has seen this or knows of a way around it let me know. Thank you http://support.microsoft.com/default.aspx/kb/213904 |
#2
|
|||
|
|||
Excel 2007 to 2003 "Too many different cell formats" error
Hi Jeremy,
That Knowledge Base (KB) article mentions the cause being 4,000 or more differing formats in a single Excel file. You may want to use the link below to also post to the MS Office Excel discussion group and mention there if you're finding that you're at that format handling size, as it could be a different cause, including some corruption in the file or something with the file format conversion between .xls and .xlsx ============ "Jeremy" wrote in message ... I was wondering if anyone else has seen this problem... When comparing documents from Excel 2007 to Excel 2003 with the compatability pack installed we have an issue where some of our larger documents when opened/saved from 2007 version cannot be opened by the 2003 version, and recieve the "Too many different cell formats". This happens irregardless if the 2007 users saved in the new format or left the document in compatability mode. Prior to 2007 these documents appeared to work correctly. I found the following KB article from Microsoft, but would rather not have to "fix" the formating in the documents. If anyone has seen this or knows of a way around it let me know. Thank you http://support.microsoft.com/default.aspx/kb/213904 -- Please let us know if this has helped, Bob Buckland ?:-) MS Office System Products MVP *Courtesy is not expensive and can pay big dividends LINKS A. Specific newsgroup/discussion group mentioned in this message: news://msnews.microsoft.com/microsoft.public.excel or via browser: http://microsoft.com/communities/new...t.public.excel B. MS Office Community discussion/newsgroups via Web Browser http://microsoft.com/office/communit...s/default.mspx or Microsoft hosted newsgroups via Outlook Express/newsreader news://msnews.microsoft.com |
#3
|
|||
|
|||
Excel 2007 to 2003 "Too many different cell formats" error
Hi Bob,
Thanks for the reply, will try posting to the other sites, will post if anything comes of it. "Bob Buckland ?:-)" wrote: Hi Jeremy, That Knowledge Base (KB) article mentions the cause being 4,000 or more differing formats in a single Excel file. You may want to use the link below to also post to the MS Office Excel discussion group and mention there if you're finding that you're at that format handling size, as it could be a different cause, including some corruption in the file or something with the file format conversion between .xls and .xlsx ============ "Jeremy" wrote in message ... I was wondering if anyone else has seen this problem... When comparing documents from Excel 2007 to Excel 2003 with the compatability pack installed we have an issue where some of our larger documents when opened/saved from 2007 version cannot be opened by the 2003 version, and recieve the "Too many different cell formats". This happens irregardless if the 2007 users saved in the new format or left the document in compatability mode. Prior to 2007 these documents appeared to work correctly. I found the following KB article from Microsoft, but would rather not have to "fix" the formating in the documents. If anyone has seen this or knows of a way around it let me know. Thank you http://support.microsoft.com/default.aspx/kb/213904 -- Please let us know if this has helped, Bob Buckland ?:-) MS Office System Products MVP *Courtesy is not expensive and can pay big dividends LINKS A. Specific newsgroup/discussion group mentioned in this message: news://msnews.microsoft.com/microsoft.public.excel or via browser: http://microsoft.com/communities/new...t.public.excel B. MS Office Community discussion/newsgroups via Web Browser http://microsoft.com/office/communit...s/default.mspx or Microsoft hosted newsgroups via Outlook Express/newsreader news://msnews.microsoft.com |
#4
|
|||
|
|||
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 workong. I have tried it and looks work. Thank you. Bram -- bram ------------------------------------------------------------------------ bram's Profile: http://forums.techarena.in/members/94463.htm View this thread: http://forums.techarena.in/ms-office-support/810164.htm http://forums.techarena.in |
#5
|
|||
|
|||
Excel 2007 to 2003 "Too many different cell formats" error
thanx.. It really works!! -- RAJA DUTTA ------------------------------------------------------------------------ RAJA DUTTA's Profile: http://forums.techarena.in/members/124148.htm View this thread: http://forums.techarena.in/ms-office-support/810164.htm http://forums.techarena.in |
Thread Tools | |
Display Modes | |
|
|