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

[Guest]

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

 

[Franz Verga]

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

Hi Alireza,

maybe this links would be useful for you:

http://support.microsoft.com/kb/213904/en-us

http://exceltips.vitalnews.com/Pages/T0213_No_More_Custom_Formats_Can_Be_Added.html


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

 

[Stephane Rodriguez]

For what it matters,

http://xlsgenreduction.arstdesign.com/

 

[Stephane Rodriguez]

In case this was not clear enough,

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. ;-)