Microsoft KB Archive/134744

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

Article ID: 134744

Article Last Modified on 8/16/2005

-

APPLIES TO


 * Microsoft Office 95 Standard Edition
 * Microsoft Excel 95 Standard Edition

-



This article was previously published under Q134744





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|''!'\ ! !'}

where  is the path to and the name of the Binder that contains the linked worksheets, is the name of the section in the Binder that contains the linked cell, is the name of the worksheet that contains the linked cell, and  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.

Keywords: KB134744

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.