Make and save changes using Microsoft Excel
When you save an entire workbook without interactivity, you can open the Web page that Excel creates (an HTML version of the file with an .htm extension), modify the data, and save the file in Excel.
In Excel, open the Web page (.htm file) that you saved as an entire workbook without interactivity.
Make changes.
Click Save on the File menu.
Note You can also open and modify parts of a workbook that you save without interactivity
When you save Excel data with interactivity, you should not open the Web page that Excel creates (an HTML version of the file with an .htm extension) in Excel. Instead, you should modify the original workbook (.xls) file from which you published, make changes, and republish to a Web page.
In Excel, open the workbook (.xls) from which you originally published the Web page.
Make changes.
Click Save as Web page on the File menu.
Click Publish.
To republish a worksheet or item that you have already published, select Previously published items and then select the worksheet or item you want to republish. To prevent an item from being republished, select the item and click Remove. To continue publishing, click another item in the list.
Click Publish.
Check the AutoRepublish every time this workbook is saved box (Publish dialog box) to specify that previously published items should be automatically republished every time the original workbook is saved.
If you do not have access to the original workbook, you can export interactive spreadsheets and PivotTable lists to Excel by using the control's Export to Microsoft Excel
toolbar button in the Web browser or use Microsoft FrontPage 2002 or data access page Design view in Microsoft Access 2002 to change the Web page.
Make and save changes using a design program
When you want to make changes to any Web page you've saved or published in Excel (with the exception of a noninteractive entire workbook) and you don't want to modify the original workbook and republish in Excel, you can open the Web page and make the changes to it in another design program such as Microsoft Office FrontPage 2003, data access page Design view in Microsoft Office Access 2003, or Microsoft Visual Basic.
Note If your browser doesn't have an Edit button, or if clicking the Edit button opens a program other than the one you want, you can open the Web page directly in the program you want to modify it with, such as FrontPage.