DefaultWebOptions.SaveHiddenData Property (Excel)
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.
Syntax
expression .SaveHiddenData
expression A variable that represents a DefaultWebOptions object.
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