Article ID: 178086 - View products that this article applies to.
This article was previously published under Q178086
This article has been archived. It is offered "as is" and will no longer be updated.
You try to save a workbook that contains either of the following:
Then, you receive the following error message:
Not enough memory
Unable to save external link values
This problem occurs when you save a workbook that contains a link to a range of cells in a different workbook, and the range is more than 16,000 cells. This problem occurs because Microsoft Excel 97 for Windows cannot save a workbook that contains a link to an external range of more than 16,000 cells.
To work around this problem, link to multiple smaller ranges instead of one large range.
If you do not need to save a copy of the external link values, you can disable the option to save a copy of the external link values by following these steps:
To work around this problem, you can also move the sheet or the sheets that contain the external data range that you are referencing in the VLOOKUP into the same workbook that contains the VLOOKUP formulas.
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.