General discussion

Locked

Excel 97, formatting problems

By kspugh ·
After moving a spreadsheet to another workbook, I am getting this error message: too many formats in this cell, etc. Any clues? Separately both workbooks function just fine.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel 97, formatting problems

by yskiran In reply to Excel 97, formatting prob ...

SYMPTOMS
In Microsoft Excel 97 or later, when you format a cell or a range of cells, you may receive the following error message:

Too many different cell formats.
CAUSE
This problem occurs when the workbook contains more than approximately 4,000 different combinations of cell formats. A combination is defined as a unique set of formatting elements that are applied to a cell. A combination includes all font formatting (for example: typeface, font size, italic, bold, and underline), borders (for example: location, weight, and color), cell patterns, number formatting, alignment, and cell protection.

NOTE: If two or more cells share exactly the same formatting, they use one formatting combination. However, if there are any differences in formatting between the cells, each cell uses a different combination.
RESOLUTION
To resolve this problem, simplify the formatting in the workbook. For example, the following are suggestions for simplifying formatting:
Use a standard font.
Using the same font for all cells reduces the number of formatting combinations.
If you use borders in a worksheet, use them consistently.

NOTE: If you apply a border to the right side of a cell, it is not necessary to apply a border to the left side of the cell that is to the right because the borders overlap.
If you apply patterns to the cells, remove the patterns by clicking No Color in the Patterns tab of the Format Cells dialog box.
NOTE: After you simplify or standardize the formatting in the workbook, save, close, and then reopen the workbook before you apply additional cell formatting.

Collapse -

Excel 97, formatting problems

by kspugh In reply to Excel 97, formatting prob ...

I had already found the error message explanation, but yskiran included some very useful information in his answer that is much appreciated!

Collapse -

Excel 97, formatting problems

by kspugh In reply to Excel 97, formatting prob ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums