Change and save data on a Web page

Microsoft Office Excel 2003

previous page next page

ShowNoninteractive data

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.

  1. In Excel, open the Web page (.htm file) that you saved as an entire workbook without interactivity.

  2. Make changes.

  3. Click Save on the File menu.

Note  You can also open and modify parts of a workbook that you save without interactivity— such as a range, sheet, or chart. However, fewer Excel features are maintained in the file, and you may not be able to modify them as you could originally. For instance, when you save a chart as a noninteractive Web page, the chart becomes a separate image and can no longer be modified on the page. However, when you save an entire workbook without interactivity that has a chart in it, the actual chart is saved rather than just an image, and it can be modified when you reopen the file.

ShowInteractive data

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.

  1. In Excel, open the workbook (.xls) from which you originally published the Web page.

  2. Make changes.

  3. Click Save as Web page on the File menu.

  4. Click Publish.

  5. 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.

  6. Click Publish.

ShowTips

  • 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 Export to Excel button 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.

ShowMake 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.

  1. Open your Web page by using a Web browser.
  2. If an arrow appears next to the Edit button, click it and select the design program you want to use. If not, click the Edit button.
  3. Make changes and save your work. For information on saving in the application you're using, see Help for that application.

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.

previous page start next page