Method 'Add' of object 'Sheets' failed
Note that the problem may occur when you add fewer than 124 charts, especially if you use multiple fonts in worksheets in your workbook or if you use embedded charts. Also, note that if the workbook contains charts that have been added in earlier versions of Microsoft Excel, the workbook may contain more than 124 charts.
Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
To resolve the problem, you can add an entry to the registry that disables automatic font scaling for charts. To do this:
- Quit all running programs.
- Click the Start button, and then click Run.
- In the Open box, type regedit, and then click OK.
- Go to the following registry subkey (folder):HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Excel\Microsoft Excel
- Point to New on the Edit menu, and then click String Value. Type AutoChartFontScaling, and then press ENTER.
- Click Modify on the Edit menu. Type 0, in the Value Data box, and then click OK.
- Click Exit on the File menu to quit the Registry Editor.
If you are unable to obtain Microsoft Excel 97 SR-2, you may be able to work around this limitation by using either of the following methods.
Method 1: Turn Off the Auto Scale Option for Fonts in Your Charts
- Select the chart area.
- On the Format menu, click Selected Chart Area.
- Select the Font tab.
- Click to clear the Auto scale check box.
- Click OK.
Method 2: Move Charts into Another WorkbookYou may also be able to work around this limitation by moving some of the charts in your workbook into another workbook. Note that charts moved to another workbook remain linked to the data in the original workbook.
NOTE: If you remove embedded charts from a worksheet and add additional charts, the "Not enough memory" error message appears unless you first save, close, and then reopen the workbook. If you delete chart sheets or worksheets that contained embedded charts, you can then add new charts up to the limit without receiving the error message and without saving, closing, and then reopening the file.
For additional information about SR-2, please click the article number below to view the article in the Microsoft Knowledge Base:
If you attempt to add another chart to the workbook, the total number of fonts used would be 257. Because this would exceed the limit of 256 fonts, you receive a "Not enough memory" error message.
Objects Fonts per Object Total fonts used
124 chart objects 2 fonts 248 fonts
1 worksheet 1 font 1 font
used by Microsoft Excel 6 fonts 6 fonts
Total 255 fonts
Clearing the Auto scale check box for each chart may allow you to extend the maximum number of charts that can be added to the workbook.
Article ID: 168650 - Last Review: Mar 15, 2008 - Revision: 1