Dynamically Update Worksheets Published to the Web
One advantage of working with Excel over the Web is that you can make it possible for you and your colleagues to interact with Excel worksheets you have published on the Web. By adding interactivity to your worksheet, you and your colleagues can edit cell values, sort the values in the worksheet, filter, or create formulas. You can also use interactivity to update an Excel-based Web page whenever there is a change in the workbook on which the file is based.
Dynamically Update Worksheets Published to the Web
Click the Microsoft Office button.
Click Save As.
Click the Save As Type down arrow.
Click Web Page.
Click Publish.
Click the Choose down arrow.
Click the sheet that contains the data you want to update.
Select the AutoRepublish Every Time This Workbook Is Saved check box.