The information in this article applies to:
SYMPTOMSIn Microsoft Excel 97, when you click a hyperlink that is linked to a defined name or a range in another workbook, you may receive the following error message and the window of the workbook to which you are hyperlinking is hidden. CAUSEThis will occur if all of the following conditions are true:
-and- -and- RESOLUTIONTo prevent this problem from occurring, use the following syntax in the "link_location" argument of the HYPERLINK function:
So, instead of using this
you should use
-or-
If you use the incorrect syntax, the error message in the "Symptoms"
section appears, and the window of the workbook to which you are
hyperlinking becomes hidden. To unhide the workbook, follow these
steps:
MORE INFORMATION
The HYPERLINK worksheet function in Microsoft Excel 97 allows you to create
a hyperlink, or jump, to web pages and Microsoft Office documents.
Additional query words: 8.00 XL97
Keywords : kbweb xlformula |
Last Reviewed: November 4, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |