Error Message: Unable to Save External Link Values (178086)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q178086 - Microsoft Excel for Windows 95 7.0|7.0
- Microsoft Excel for Windows 95 7.0a|7.0a
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 97 for Windows 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.
- Clear the Save External Link Values option under Workbook Options and
click OK.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
| Modification Type: | Minor | Last Reviewed: | 8/19/2003 |
|---|
| Keywords: | kbbug kberrmsg kbpending KB178086 |
|---|
|