OFF95: #NAME? Error Value Appears in Linked Cell in Binder

ID: Q134744

7.00 WINDOWS kbtool

The information in this article applies to:

Microsoft Office for Windows 95, version 7.0
Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

In Office Binder, when you open a Binder that contains a Microsoft Excel worksheet section, a cell on the worksheet that contains a link may display the #NAME? error value instead of the linked value.

CAUSE

This behavior occurs if you link a cell in one section of a Binder to a cell in another section, and you then rename the section that contains the linked cell.

For example, create a binder with two Microsoft Excel worksheets in separate sections. Then copy cell A1 from Section 1, activate Section 2 cell A1, and on the Edit menu click Paste Special, Paste Link, Microsoft Excel 5.0 Format. (Note that you must use the Paste Special dialog box to create the link.) The link is updated whenever you modify the value in cell A1 in "Section 1." If you rename "Section 1" to "Sec 1," the link is still updated as long as the Binder is open in Office Binder. However, when you close the Binder, and then open the Binder again, cell A1 in "Section 2" displays the #NAME? error value.

When you create a link between worksheets in a Binder, the link appears similar to the following

   {=Excel.Sheet.5|'<path\filename>'!'\<section>!<sheet>!<R1C1>'}

where <path\filename> is the path to and the name of the Binder that contains the linked worksheets, <section> is the name of the section in the Binder that contains the linked cell, <sheet> is the name of the worksheet that contains the linked cell, and <R1C1> is the linked cell or range.

RESOLUTION

To avoid this problem, rename a Microsoft Excel worksheet section in your Binder before you link to a value on the worksheet in that section.

To work around this problem, you can update the link by doing the following:

1. Activate the section in the Binder that contains the link.

2. On the Edit menu, click Links.

3. In the list of links, click the link that is displaying the error,

   and then click Change Source.

4. In the Change Source dialog box, correct the section name from the

   previous name to the current name, and then click OK.

5. Close the Links dialog box.

KBCategory: kbtool KBSubcategory: offwin xlwin

Additional reference words: 7.00

Keywords          : offwin xlwin 
Version           : 7.00
Platform          : WINDOWS

Last Reviewed: March 28, 1997