Excel 2002 lets you easily save an Excel file as a Web page. This is not a new feature. You could do the same thing in Excel 2000. However, Excel 2002 makes it easier to update data in a worksheet that has already been saved to the Web.

You can save an Excel file as a Web page and configure it for auto republishing using the following steps:

1. Within Excel, click Save As Web page from the File menu.


2. From the Save As dialog box, click the Publish button.


3. Use the drop down arrow beside Choose to select what you want to publish.


4. In the File name field, enter a file name.


5. Place a check beside Auto Republish every time this worksheet is saved. This way the data will be updated each time you make changes to the worksheet.


6. Select Open published page in Web browser to view the data in your Web browser after you click Publish.


7. Click Publish.