[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

HYPERLINK

Syntax:

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

text

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

text, number, 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]