Article ID: 211503 - View products that this article applies to.
This article was previously published under Q211503
In Microsoft Excel, 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.
Cannot open the specified file.
This will occur if all of the following conditions are true:
To prevent this problem from occurring, use the following syntax in the "link_location" argument of the HYPERLINK function:
[workbook name]defined name or range
So, instead of using this
you should use
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:
The HYPERLINK worksheet function in Microsoft Excel allows you to create a hyperlink, or jump, to web pages and Microsoft Office documents.
If you use the HYPERLINK function to create a link to a defined name within a Microsoft Excel workbook, you must use the [workbook name]defined name syntax when you refer to the defined name. If you use the more traditional workbook name!defined name or range syntax, the hyperlink may not work correctly.