Robert
From the Excel Help
Modify and republish data on a Web page that was previously saved by Excel
When you publish or save your Microsoft Excel data as a Web page, Excel
creates an HTML version of the file (with the extension .htm). If you want
to update that data on the Web page, and you saved or published a worksheet
or items on a worksheet, you can republish the data by opening your original
workbook (.xls) file, not the .htm file, to make the changes. Then when you
republish the data, Excel replaces only the data you select.
1.. Open the workbook (.xls file) that you previously saved as a Web page
and now want to modify.
2.. Modify the data, and then resave the workbook as an .xls file.
3.. Select the worksheet or item in the workbook that you want to update
on the Web page.
4.. On the File menu, click Save as Web Page.
5.. Click Publish.
6.. If you want to change the type of interactivity, title, or location of
the Web page, make the appropriate changes in the dialog box.
7.. If you want to view the Web page in the browser after you publish it,
select the Open published Web page in browser check box.
8.. Click Publish.
Notes
a.. Republishing a workbook You can't use this procedure to republish an
entire workbook. To republish an entire workbook as a Web page, you can open
the .htm file in Excel and make changes directly to the Web page file.
b.. Republishing a worksheet with an interactive chart If you republish
a worksheet that contains a chart and you select interactive functionality,
the chart is not included on the Web page. To put a chart on a Web page, you
must save or publish it separately.
Don't know if this will help you but you could explore the rest of the Help
on "Publish"
Regards
Trevor
