"Not enough memory" error message when you open an Excel 97 workbook

Veralteter Haftungsausschluss für KB-Inhalte

Dieser Artikel wurde für Produkte geschrieben, für die Microsoft keinen Support mehr anbietet. Deshalb wird dieser Artikel im vorliegenden Zustand bereitgestellt und nicht mehr aktualisiert.

Symptoms

When you open a workbook, or change the font for a cell, you receive the following error message:

Not enough memory.

Cause

This problem occurs when the number of fonts in the workbook approaches or exceeds 255. Note that Excel counts fonts of different sizes as separate fonts. For example, Excel counts Arial 10 point and Arial 12 point as two fonts.

You receive the error message when you do either of the following:

  • You open a workbook that was created in Microsoft Excel 2000 and saved in the Microsoft Excel 97-2000 & 5.0/95 Workbook (*.xls) format.

    -or-
  • You change the font for a cell in a workbook.

Workaround

To work around this error message, follow these steps:

  1. Unhide any hidden worksheets. (On the Format menu, point to Sheet, and then click Unhide.)
  2. Hold down SHIFT and click each worksheet tab to select all worksheets.
  3. Press CTRL+A to select all cells.
  4. On the Format menu, click Style.
  5. In the Style name list, click Normal.
  6. Click to clear every check box except for the Font check box.
  7. Click OK. Save the workbook.
All fonts now have the same size and name, which eliminates the error message.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

215573 You receive an error message when you add a chart to a workbook in Excel

Eigenschaften

Artikelnummer: 255622 – Letzte Überarbeitung: 06.12.2004 – Revision: 1

Feedback