The information in this article applies to:
SYMPTOMSWhen you format a cell or a range of cells in Microsoft Excel, you may receive the following error message:
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.
RESOLUTION
To prevent this problem from occurring, simplify the formatting in the
workbook. For example, the following are suggestions for simplifying
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 |
Last Reviewed: April 14, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |