Edit

Share via

DefaultWebOptions.UpdateLinksOnSave property (Excel)

  • Article

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.