Microsoft KB Archive/239184

= Works 2000: "Not Enough Memory" Error Message When You Import an Excel Spreadsheet =

Article ID: 239184

Article Last Modified on 1/25/2007

-

APPLIES TO


 * Microsoft Works 2000 Standard Edition
 * Microsoft Works Suite 2000

-



This article was previously published under Q239184



SYMPTOMS
When you import a Microsoft Excel Spreadsheet file, the following (or a similar) error message may appear:

There is not enough memory for new formats.

To apply new formats, remove old formats from your selection, or close other documents or applications.

This error message may appear even when the Excel worksheet that you are attempting to import contains no special formatting.



CAUSE
This issue can occur because some worksheets in the workbook contain a large amount data or a large number of specially formatted cells. Even when you intend to import only one sheet of an Excel workbook, the import converter looks at all of the workbook.



RESOLUTION
To work around this issue, follow these steps:
 * 1) Start Microsoft Excel.
 * 2) On the File menu, click Open.
 * 3) Navigate to the workbook containing the worksheet that you want to import to Microsoft Works 2000 Spreadsheet, and then click Open.
 * 4) Click the sheet tab of the worksheet that you want.
 * 5) On the File menu, click Save As.
 * 6) In the Save as type box, select Microsoft Excel 4.0 Worksheet.
 * 7) Name the file, and then click Save. You can now open the individual worksheet that you want with the Works 2000 Spreadsheet program.



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: w_works works2K

Keywords: kbbug kberrmsg kbpending KB239184

-

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

© Microsoft Corporation. All rights reserved.