| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I know the no of different cell formats in a Excel workbo.
Dear All,
I am facing a problem with no of cell formats... And every second day our IT dapartment facing a problem like "excel file corrupt". When we try to open the file finding error "Too many cell formats"... Is there any permenent solution to this? Pls. Help .... |
|
#2
|
|||
|
|||
|
Sunil
You will get this message when the no. of cell formats gets to about 4000. This KB article addresses this problem. http://support.microsoft.com/default...b;en-us;213904 The permanent fix is: don't use so many formats. Gord Dibben Excel MVP On Mon, 31 Jan 2005 01:29:10 -0800, "Sunil" <Sunil @discussions.microsoft.com wrote: Dear All, I am facing a problem with no of cell formats... And every second day our IT dapartment facing a problem like "excel file corrupt". When we try to open the file finding error "Too many cell formats"... Is there any permenent solution to this? Pls. Help .... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel tab key to move to right adjacent cell | Excel Discussion (Misc queries) | |||
| I have typed in an excel cell and cannot advance to next cell by . | Excel Discussion (Misc queries) | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
| Writing many lines on a same Excel 2000 cell | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
