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.
expression A variable that represents a DefaultWebOptions object.
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.
This example specifies that links are not updated before the document is saved.
Application.DefaultWebOptions.UpdateLinksOnSave = False