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

[Jeremy]

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

 

[Bob Buckland ?:-\)]

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

============
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

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com

 

[Jeremy]

Hi Bob,

Thanks for the reply, will try posting to the other sites, will post if
anything comes of it.

 

[bram]

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

 

[RAJA DUTTA]

thanx..
It really works!