UPDATE.LINK

Macro Sheets Only

Equivalent to choosing the Links command from the Edit menu and choosing the Update Now button with a link selected in the Links dialog box. Updates a link to another document. Use UPDATE.LINK to get the newest information from a supporting document.

Syntax

UPDATE.LINK(link_text, type_of_link)

Link_text is a text string describing the full path of the link as displayed in the Links dialog box. If link_text is omitted, only links from the active workbook to other Microsoft Excel workbooks are updated.

Type_of_link is a number from 1 to 4 that specifies the type of link to update.

Type_of_link Link document type

1 or omitted Microsoft Excel link

2 DDE link

3 Not available

4 Not available

Related Functions

CHANGE.LINK Changes supporting links

GET.LINK.INFO Returns information about a link

OPEN.LINKS Opens specified supporting documents

List of Command-Equivalent Functions