XL Err Msg: "Too Many Different Cell Formats"

ID: Q163678

The information in this article applies to:

Microsoft Excel 97 for Windows
Microsoft Excel for Windows 95, versions 7.0, 7.0a
Microsoft Excel for Windows, versions 5.0, 5.0c
Microsoft Excel for the Macintosh, version 5.0, 5.0a

SYMPTOMS

When you format a cell or a range of cells in Microsoft Excel, 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, underline, and so on), borders (for example, location, weight, color, and so on), 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 prevent this problem from occurring, 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 that 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.

MORE INFORMATION

In most cases, the limit of approximately 4,000 different formatting combinations for a single workbook is sufficient. This problem is likely to occur only when the workbook contains a large number of worksheets that use different formatting, or when a large number of cells are all formatted differently.

Additional query words: XL97


Keywords          : kberrmsg kbualink97 xlformat 
Version           : WINDOWS:97,7.0,7.0a,5.0,5.0c; MACINTOSH:5.0,5.0a
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: April 14, 1999