Too many formatted cells error message

N

nsando

I have 1.25mb file, mostly data, and some macro buttons, no fancy
formulas. When I attempted to merge a cell, received the error message.
After I saved and reopened, the file was corrupted.
What is the solution/prevention for this on new files?
 
D

Dave Peterson

Use fewer formats???

And as a personal preference I do my best to stay away from merged cells.

Maybe...

XL: Error Message: Too Many Different Cell Formats
http://support.microsoft.com/default.aspx?scid=213904

A few people have said that OpenOffice.Org has been able to open the file. Then
they clean it up and save it there. Then excel can open that cleaned up
version.

http://www.openoffice.org, a 60-104 meg download or a CD

=====
If you still have your older version, you may want to see if OpenOffice can
"de-corrupt" it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

too many different cells format 3
Too Many Different Cell Format 3
what does error message "too many adjustable cells" mean in solver 1
Recover .xls file with "Too many different cell formats" error 1
Excel Error :- "Too Many Cell Formats"...is there a way of finding 4
Unknown Error Message 2
What does too many different cell formats mean? 2
Merging or "Merging" 1

Top