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