You’re now ready to save your spreadsheet as an HTML file by clicking the Save button. If you want to see how this file looks in your web browser immediately upon saving it, click the Publish button to open the Publish as Web Page dialog box and save the file from there after selecting the Open Published Web Page in Browser check box.
And if you want Excel to automatically save an HTML version of the worksheet each time you save the workbook, you select the AutoRepublish Every Time This Workbook Is Saved check box as well.