OFF97: Error Inserting Hyperlink in an Embedded DocumentLast reviewed: December 6, 1996Article ID: Q159626 |
The information in this article applies to:
SYMPTOMSIf you click the Browse button for the "Named location in file (optional)" edit box in the Insert Hyperlink dialog box, you may receive the following error:
Microsoft Excel either could not connect to the file you specified, or the file is not a Microsoft Excel workbook. Please verify that: - The path or URL and the file name are correct. - You can connect to the file from your Web browser. - The file is a Microsoft Excel workbook. If the file is an Office file, and you know the location you want, such as a Word bookmark or a PowerPoint slide, type the location in the Named Location In File box. - If you don't know the location, leave the Named Location In File box blank, and your hyperlink will jump to the file. CAUSEYou may receive this error message if all of the following are true:
RESOLUTIONYou will not be able to browse to a named location in the active workbook if the workbook is embedded in a Word document. In order to create a hyperlink to a named location in the active embedded workbook, you will have to manually enter the named location in the "Named location in file (optional)" edit box. For example, if you have two worksheets, Sheet1 and Sheet2, in your embedded workbook, and you want to create a hyperlink to a defined name, "myrange" (referring to cell A1 in Sheet2), in cell A1 of Sheet1, do the following:
STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
MORE INFORMATIONIf your workbook is not embedded in a Word document and you click the Browse button for the "Named location in file (optional)" edit box, the Browse Excel Workbook dialog box will appear. In this dialog box, all the worksheets in the workbook will be listed and there is an option button for Defined Name. When you click the Defined Name button, all the defined names in the workbook are displayed in the list below the button. If you click any of the defined names and then click OK, this defined name will be entered in the "Named location in file (optional)" edit box.
REFERENCESFor more information about Hyperlinks, click the Index tab in Microsoft Excel Help, type the following text
hyperlinks, creatingand then double-click the selected text to go to the "Create a hyperlink" topic.
|
KBCategory: kberrmsg kbtool kbusage
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |