SaveHiddenData Property

Microsoft Excel Visual Basic

True if data outside of the specified range is saved when you save the document as a Web page. This data may be necessary for maintaining formulas. False if data outside of the specified range is not saved with the Web page. The default value is True. Read/write Boolean.

Remarks

If you choose not to save data outside of the specified range, references to that data in the formula are converted to static values. If the data is in another sheet or workbook, the result of the formula is saved as a static value.

Example

This example prevents hidden data from being saved with Web pages.

Application.DefaultWebOptions.SaveHiddenData = False