DefaultWebOptions.UpdateLinksOnSave property (Excel)
True if hyperlinks and paths to all supporting files are automatically updated before you save the document as a webpage, 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
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.