Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
XL97: "Not Enough Memory" Error Using Linking Formulas
Article ID: 167079 - View products that this article applies to.
This article was previously published under Q167079
In Microsoft Excel 97, when you do any of the following
In addition, cells that contain formulas that are linked to other workbooks may return the #REF! error value.
Not enough memory.
This problem occurs if formulas in your workbook are linked to more than 16,375 unique cells in any one worksheet in a closed workbook. For a more detailed description of this limitation, see the "More Information" section in this article.
To work around this problem, use one of the following methods.
Method 1Open the workbook that contains the cells to which the formulas are linked (the source workbook). The limitation described in this article does not apply when the formulas are linked to cells in an open workbook.
Method 2Split the data in the source workbook into multiple worksheets, and then modify the formulas in the dependent workbook to account for the change in worksheet names. This method works because the limitation applies to each worksheet to which the formulas are linked. The limitation does not apply to the entire workbook.
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
For the following example and information, assume that you are using the following three workbooks:
Book1.xls (source workbook)Each workbook contains three worksheets, Sheet1, Sheet2, and Sheet3. Book1.xls and Book2.xls contain values in A1:A17000 on each worksheet (cells are not blank).
Book2.xls (source workbook)
Book3.xls (dependent workbook)
When you use a workbook with formulas that link to other workbooks in Microsoft Excel 97, the following rules apply:
ExamplesTo see an example of the behavior, do the following:
and then fill the formula down to row 16,376, you receive the error message because Book3.xls contains links to more than 16,375 different cells on Sheet1 of Book2.xls.
Article ID: 167079 - Last Review: October 21, 2000 - Revision: 1.0