Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
what is the problem" TOO MANY DIFFERENT CELL FORMATS"?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
what is the problem" TOO MANY DIFFERENT CELL FORMATS"?
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 Alireza wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
what is the problem" TOO MANY DIFFERENT CELL FORMATS"?
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/ma...938821033.aspx And directly here : http://xlsgenreduction.arstdesign.com/ Let me know what you think. ;-) -- xlsgen - native Excel generator http://xlsgen.arstdesign.com xlsgen RSS feed : http://www.arstdesign.com/BBS/rssxlsgen.php "Alireza" a écrit dans le message de ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Too Many Cell Formats" Error when opening a 2007 XLS file in 2003 | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
"too many different cell formats". How to solve this problem? | Excel Discussion (Misc queries) | |||
what is the problem" TOO MANY DIFFERENT CELL FORMATS"? | Excel Worksheet Functions | |||
what is the problem" TOO MANY DIFFERENT CELL FORMATS"? | Excel Discussion (Misc queries) |