XL2000: Error Message: Unable to Save External Link Values (214342)

SYMPTOMS

When you attempt to save a workbook that contains either of the following

a link to a large range of cells in another workbook (approximately 16,000 cells)

-or-
too many cells that are linked to a cell in another workbook

you receive the following error message:

Not enough memory

Then, you receive the following error message:

Unable to save external link values

CAUSE

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 2000 cannot save a workbook that contains a link to an external range of more than 16,000 cells.

WORKAROUND

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:

Switch to the workbook that contains the link formulas.
On the Tools menu, click Options.
Click the Calculation tab in the Options dialog box.
Under Workbook options, click to clear the Save external link values check box, and click OK.

STATUS

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