Microsoft KB Archive/94719

= Microsoft Knowledge Base =

Excel: UPDATE.LINK Function Returns Error
Last reviewed: September 12, 1996

Article ID: Q94719

The information in this article applies to:


 * Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a, 5.0
 * Microsoft Excel for the Macintosh, versions 3.0, 4.0, 5.0

SUMMARY
When you use the UPDATE.LINK function in a macro and you do not specify any parameters, the following will occur:

 Microsoft Excel will return a macro error. -and- A #VALUE! error value will be placed in the cell on the macro sheet that contains the UPDATE.LINK function.

Page 443 of the version 4.0 &quot;Microsoft Excel Function Reference&quot; manual states that the LINK_TEXT and TYPE_OF_LINK parameters are optional. However, the documentation should include the information that for the UPDATE.LINK function to work correctly, the comma used to separate the LINK_TEXT and TYPE_OF_LINK arguments must be included even if the parameters are not included.

To update all links on the active worksheet with a macro, use the following command:

=UPDATE.LINK