Article ID: 179040
Article Last Modified on 1/22/2007
APPLIES TO
- Microsoft Excel 2001 for Mac
- Microsoft Excel 98 for Macintosh
This article was previously published under Q179040
SYMPTOMS
If you click
AutoFormat on the
Format menu, select a format, and then click
OK, you may receive the following error messages:
Not enough memory.
Continue without Undo?
Not enough memory.
CAUSE
These problems may occur if you select an entire worksheet (65,536 rows by
256 columns), click AutoFormat on the Format menu, select a format, and then click OK.
WORKAROUND
To prevent these problems from occurring, make sure that you select only
the specific range that you want to format before you click AutoFormat on the Format menu.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
MORE INFORMATION
In Microsoft Excel, you can use the AutoFormat feature to apply a
predesigned combination of formats to a range of cells. A number of
automatic formats are available. Each one uses a complex set of "rules" to
determine what formats to apply to each cell in the specified range.
Worksheets in Microsoft Excel contain a maximum of approximately 16.7 million cells. When you select an entire worksheet, either by clicking Select All in the upper-left corner of the worksheet or by pressing CTRL+SHIFT+SPACEBAR, and then attempt to apply a format in the
AutoFormat dialog box, Microsoft Excel cannot format the cells. Microsoft Excel cannot format that many cells at once.
Additional query words: XL2001 XL98 auto format
Keywords: kberrmsg kbprb KB179040