Reducing the File Size of a Web Page in Excel

One of the features of Excel for Windows is the ability to save a Workbook in HTML format.

In Excel if you publish or save data on the Web and add interactivity with spreadsheet functionality, and your worksheet contains formulas that reference data that is not in your selected range, you can reduce the file size by not saving the external referenced data.

---

How To Reduce the File Size of a Web Page

1. From the Tools menu, click Options, and then click the General tab.
2. Click Web Options, and then click the General tab.
3. Clear the Save any additional hidden data necessary to maintain formulas check box.

• This option applies to the current page and any future pages that you save in Excel.
• If you choose not to save the hidden data, formulas that reference that data are replaced by the formulas' calculated values.