[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
HYPERLINK ( link-location [ , [ friendly-name ] ] )
Description: Creates a shortcut that opens a document stored on a network server, an intranet, or the Internet. When the cell that contains the HYPERLINK function call is clicked, the file stored at link-location is opened.
Arguments:
|
Name |
Type |
Description |
|
link-location |
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 SpreadsheetML worksheet or workbook, or to a bookmark in a WordprocessingML 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 or a Uniform Resource Locator (URL) path on the Internet or an intranet. If the path specified in link-location does not exist or cannot be navigated, an unspecified error is produced when the cell is clicked. link-location can be a string or a reference to a cell containing a string. | |
|
friendly-name |
The value that is displayed in the cell. If omitted, the cell displays link-location. friendly-name can be a value, a text string, a name, or a cell that contains the jump text or value. If the evaluation of friendly-name results in an error value, the cell displays that error value rather than the jump text. |
Return Type and Value: text – The value of friendly-name, if it is specified; otherwise, the value of link-location.
[Example:
HYPERLINK("http://example.openxmlformats.org/report/budget report.xls","Click for report"), which opens a worksheet named "budget report.xls" that is stored on the Internet at the location example.openxmlformats.org/report, and displays the text "Click for report".
HYPERLINK("D:\FINANCE\1stqtr.xls",H10), which opens the file 1stqtr.xls that is stored in a directory named Finance on drive D, and displays the numeric value stored in cell H10.
end example]