Microsoft Office Tutorials and References
In Depth Information
Dynamically updating worksheets published to the web
Update worksheets published to the web
5 Click the Save As Type down arrow.
6 Click Web Page.
7 Click Publish.
8 Click the Choose down arrow.
9 Click the sheet that contains the data that you want to update.
10 Click the element that you want to publish.
11 Select the AutoRepublish Every Time This Workbook Is Saved check
12 Click Publish.