Microsoft KB Archive/264986

= XL97: Error Copying Worksheets Containing Charts =

PSS ID Number: 264986

Article Last Modified on 5/17/2001

-

The information in this article applies to:


 * Microsoft Excel 97 for Windows

-



This article was previously published under Q264986





SYMPTOMS
When you copy a worksheet with embedded chart objects several times, you may receive the following error message:

Not enough memory.



CAUSE
This problem occurs if all of the following are true:


 * You created a chart object in the worksheet.

-and-


 * The chart object contains a title.

-and-


 * You pasted a chart object on the same worksheet ten or more times.

-and-


 * You copied the worksheet several times in the same workbook.



WORKAROUND
To workaround this behavior, use either of the following methods.

Method 1: Disable Autoscaling in the Chart

 * 1) Click the chart.
 * 2) On the Format menu, click Selected Chart Area.
 * 3) Click the Font tab.
 * 4) Click to clear the Autoscale check box.
 * 5) Click OK.

Method 2: Split the Number of Charts into Multiple Workbooks
You can cut some of your charts in your workbook and paste them into one or more new workbooks to decrease the amount of resources that each workbook needs.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: XL97

Keywords: kbprb KB264986

Technology: kbExcel97Search kbExcelSearch kbExcelWinSearch kbZNotKeyword3

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© 2004 Microsoft Corporation. All rights reserved.