Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Too many different cell format
Dear All
I have a quite big excel and i am trying to make some changes in format and i receive the message "Too many different cell format" Probably i have many different cell formats. From where i can set up the format in order to know what must be the format of the excel file? I need away to identify the format from all sheets in order to give to the all sheets as common format as i can. Any ideas? |
#2
|
|||
|
|||
Some info:
XL: Error Message: Too Many Different Cell Formats http://support.microsoft.com/default.aspx?scid=213904 I'd remove some of the formatting. (maybe format per column??) If it gets too bad, you may not be able to reopen your workbook. If that happens, then a few people have posted that they could open the file in OpenOffice, then remove some of the formatting, save it and then excel would open that file ok. http://www.openoffice.org, a 60-65 meg download or a CD Microsoft wrote: Dear All I have a quite big excel and i am trying to make some changes in format and i receive the message "Too many different cell format" Probably i have many different cell formats. From where i can set up the format in order to know what must be the format of the excel file? I need away to identify the format from all sheets in order to give to the all sheets as common format as i can. Any ideas? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference Cell in custom format???? | Excel Discussion (Misc queries) | |||
Why does my format keep changing in the cell? | Excel Discussion (Misc queries) | |||
how do I format a cell reference to move as source changes | Excel Worksheet Functions | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
How do I unhide the cell format function in Excel 2000 | Excel Worksheet Functions |