As with previous versions of Excel, Excel 2007 lets you save an excel file as a Web page. You can even have the data updated automatically using the Autorepublishing feature. To save an Excel 2007 file as Web page and configure it for autorepublishing using the following steps:

  1. Within Excel, click Save As Web Page from the Microsoft Office Button.
  2. Select one of the following options:
    • To save to a Web page and create supporting files and folders, select Web Page (*.htm; *.html).
    • To save to a Single File Web page with supporting files embedded in the Web page, select Single File Web Page (*.mht; *.mhl)
  3. Select either Entire Workbook or Select: Sheet.
  4. Click Publish and select the item you want to publish (i.e. Entire workbook, Entire worksheet, Items, Ranges of cells, Charts, Filtered ranges, External data ranges, Republishing).
  5. In the File name box, enter in a file name. Click Browse to find the location where you want to save the web page.
  6. Click OK.
  7. Place a check beside AutoRepublish every time this worksheet is saved. This way the data will be updated each time you make changes to the worksheet.
  8. Select Open published page in Web browser to view the data in your Web browser after you click Publish.
  9. Click Publish.