DefaultWebOptions.SaveHiddenData property (Excel)
True if data outside of the specified range is saved when you save the document as a webpage. This data may be necessary for maintaining formulas. False if data outside of the specified range is not saved with the webpage. The default value is True. Read/write Boolean.
expression A variable that represents a DefaultWebOptions object.
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.
This example prevents hidden data from being saved with webpages.
Application.DefaultWebOptions.SaveHiddenData = 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.