You are currently offline, waiting for your internet to reconnect

Error message in Excel: "Unable to save external link values"

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article was previously published under Q214342
SYMPTOMS
When you try to save a workbook that contains either 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 in Microsoft Excel 2000:
Not enough memory.
Then, you receive the following error message:
Unable to save external link values.
In Microsoft Office Excel 2003 and in Microsoft Excel 2002, you receive the following error message:
Excel cannot complete this task with available resources. Choose less data or close other applications.
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 arange of cells in a different workbook, and the range is more than 16,000cells. 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 ofone large range.

If you do not need to save a copy of the external link values, you candisable the option to save a copy of the external link values by followingthese steps:
  1. Switch to the workbook that contains the link formulas.
  2. On the Tools menu, click Options.
  3. Click the Calculation tab in the Options dialog box.
  4. Under Workbook options, click to clear the Save external link values check box, and click OK.
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.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
XL2000
Properties

Article ID: 214342 - Last Review: 07/24/2007 16:06:00 - Revision: 5.0

  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
  • kberrmsg kbbug kbpending KB214342
Feedback