DefaultWebOptions.UpdateLinksOnSave Property (Excel)
True if hyperlinks and paths to all supporting files are automatically updated before you save the document as a Web page, ensuring that the links are up-to-date at the time the document is saved. False if the links are not updated. The default value is True. Read/write Boolean.
Syntax
expression .UpdateLinksOnSave
expression A variable that represents a DefaultWebOptions object.
Remarks
You should set this property to False if the location where the document is saved is different from the final location on the Web server and the supporting files are not available at the first location.
Example
This example specifies that links are not updated before the document is saved.
Application.DefaultWebOptions.UpdateLinksOnSave = False