what is the problem" TOO MANY DIFFERENT CELL FORMATS"?

[Alireza]

Hi,
I faced with a problem in my excel sheet. I made a big table with about 2400
cells. I used hyperlink files in one column. But recently I faced a problem
if I want format a cells, for example: merge two cells, it will send a
massage TOO MANY DIFFERENT CELLS FORMATS" and deny of do it. I don't knew
what happen in my excel sheet. I checked this sheet in another computer, I
haven't any problem. But in new computer, I couldn't use hyperlink of the
files.
Your reply will be highly appreciated.

Alireza

 

[Dave Peterson]

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

 

[Stephane Rodriguez]

There is a tool that helps you analyze, reduce and streamline the formatting
styles in your workbooks. It's a fix to the "too many different cell
formats" problem so many Excel users seem to experience.

It's available from the Office market place here :

http://office.microsoft.com/en-us/marketplace/EM101938821033.aspx


And directly here :

http://xlsgenreduction.arstdesign.com/


Let me know what you think. ;-)