Manuals/calci/HYPERLINK

HYPERLINK(link_loc, name)

• where link_loc is the path of the document or file
• name is the name of the document or file to open.

HYPERLINK() creates a shortcut that opens a document stored on a network server.

Description

• A hyperlink is a reference that points to data or a document. By clicking on the cell that contains HYPERLINK function, Calci opens the specified document.
• link_loc can be a text string enclosed in quotation marks or a cell that contains the link as a text string.
• link_loc can be a reference to a word document, a spreadsheet, any image on server or internet etc.
• If the jump location specified in the argument does not exist or cannot be navigated, Calci displays an error.
• name is the text or a numeric value. If name is omitted, the link location is displayed as jump text.

Examples

Click Here
C:\Profile\My_Profile.doc

HYPERLINK can be used in following ways -

1)To open a Google website from Calci spreadsheet, following command can be used -

=HYPERLINK("http://www.google.com","Click here")

2)To open a Microsoft word document "My_Profile" stored on C drive of computer, following command can be used -

=HYPERLINK("C:\Profile\My_profile.doc","My_Profile")

Related Videos

HYPERLINK

See Also

• ADDRESS

Reference

• Hyperlink

• List of Main Z Functions

• Z3 home