External Link in WK4 File Displays #REF! Error Value (123262)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
This article was previously published under Q123262 SYMPTOMS
In Microsoft Excel, when you open a Lotus 1-2-3 .wk4 file that contains
a link to another file, you receive one of the following error messages:
Microsoft Excel 97
The workbook you opened contains automatic links to information in
another workbook. Do you want to update this workbook with changes
made to the other workbook?
When you click Yes, the cells are updated with the values. However, when
you click No, the cells on the worksheet that contain a link to another
file display the #REF! error value.
Microsoft Excel 7.0
This document contains links. Re-establish links?
When you click Yes, the cells are updated with the values. However, when
you click No, the cells on the worksheet that contain a link to another
file display the #REF! error value.
Microsoft Excel 5.0
This document contains links. You can re-establish them with the
Edit Links command.
When you click OK, the cells on the worksheet that contain a link to
another file display the #REF! error value.
CAUSE
This behavior occurs when you open a Lotus 1-2-3 .wk4 file that contains a
link to another file, such as another Lotus 1-2-3 .wk4 file.
WORKAROUND
To update an external link in a Lotus 1-2-3 .wk4 file in Microsoft Excel,
follow these steps:
- In Microsoft Excel, open the Lotus 1-2-3 WK4 file.
- Click OK in the dialog box that indicates that the document contains
links.
- On the Edit menu, click Links.
- In the Links dialog box, select the link that you want to update.
- Click Update Now.
NOTE: If you want to open the source document, click Open. This
also updates the external link.
To avoid this behavior, save the file in the Microsoft Excel workbook
format.
MORE INFORMATION
To open a Lotus 1-2-3 .wk4 file in Microsoft Excel 5.0, obtain the Lotus
1-2-3 .wk4 file converter. The Lotus 1-2-3 .wk4 file converter is
available in the "Lotus 1-2-3 WK4 File Converter" (WE1130 ) Application
Note. Lotus 1-2-3 is manufactured by Lotus Corporation, a vendor independent of
Microsoft; we make no warranty, implied or otherwise, regarding this
product's performance or reliability.
REFERENCES
"Lotus 1-2-3 WK4 File Converter" Readme.txt
For more information about updating source data, click the Index tab in
Microsoft Excel Help, type the following text
and then double-click the selected text to go to the " Update a link to
data on your intranet or the Internet" topic.
| Modification Type: | Minor | Last Reviewed: | 8/15/2005 |
|---|
| Keywords: | kb3rdparty kbualink97 KB123262 |
|---|
|