Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet. When you click the cell that contains the HYPERLINK function, Microsoft Excel 97 opens the file stored at link_location.
Link_location is the path and file name to the document to be opened as text. Link_location can refer to a place in a document — such as a specific cell or named range in a Microsoft Excel worksheet or workbook, or to a bookmark in a Microsoft Word document. The path can be to a file stored on a hard disk drive, or the path can be a universal naming convention (UNC) path on a server (in Microsoft Excel 97 for Windows) or a Uniform Resource Locator (URL) path on the Internet or an intranet.
Cell_contents is the jump text or numeric value that is displayed in the cell. The cell contents is displayed in blue and is underlined. If cell_contents is omitted, the cell displays the link_location as the jump text.
- Link_location can be a text string enclosed in quotation marks or a cell that contains the link as a text string.
- Cell_contents can be a value, a text string, a name, or a cell that contains the jump text or value.
- If cell_contents returns an error value (for example, #VALUE!), the cell displays the error instead of the jump text.
- If the jump specified in link_location does not exist or cannot be navigated, an error appears when you click the cell.
- To select a cell that contains HYPERLINK, click a cell next to the cell, and then use an arrow key to move to the cell.
The following example opens a worksheet named Budget Report.xls that is stored on the Internet at the location named
www.business.com/report and displays the text "Click for report":
HYPERLINK("http://www.business.com/report/budget report.xls", "Click for report")
The following example creates a hyperlink to cell F10 on the worksheet named Annual in the workbook Budget Report.xls, which is stored on the Internet at the location named
www.business.com/report. The cell on the worksheet that contains the hyperlink displays the contents of cell D1 as the jump text:
HYPERLINK("'[http://www.business.com/report/budget report.xls]Annual'!F10", D1)
The following example creates a hyperlink to the range named DeptTotal on the worksheet named First Quarter in the workbook Budget Report.xls, which is stored on the Internet at the location named
www.business.com/report. The cell on the worksheet that contains the hyperlink displays the text "Click to see First Quarter Department Total":
HYPERLINK("'[http://www.business.com/report/budget report.xls]First Quarter'!DeptTotal", "Click to see First Quarter Department Total")
To create a hyperlink to a specific location in a Microsoft Word document, you must use a bookmark to define the location you want to jump to in the document. The following example creates a hyperlink to the bookmark named QrtlyProfits in the document named Annual Report.doc located at
HYPERLINK("'[http://www.business.com/Annual Report.doc]#QrtlyProfits", "Quarterly Profit Report")
In Microsoft Excel 97 for Windows, the following example displays the contents of cell D5 as the jump text in the cell and opens the file named 1stqtr.xls, which is stored on the server named FINANCE in the Statements share. This example uses a UNC path:
The following example opens the file 1stqtr.xls in Microsoft Excel 97 for Windows that is stored in a directory named Finance on drive D, and displays the numeric value stored in cell H10: