SUMMARY
This step-by-step article explains how to use the AutoRepublish feature. Microsoft Excel 2002 has a new feature, AutoRepublish, which allows you to automatically update a Web page as the workbook from which it was created is updated.
AutoRepublish is an automatic link from a Web page to an Excel workbook. When AutoRepublish is turned on, the Web page is automatically updated every time that the workbook that it was created from is saved.
back to the top
Turn On AutoRepublish
To turn on the AutoRepublish feature, follow these steps:
- Start Excel, and then open or create the workbook that you want to save as a Web page.
- Click Save as Web Page.
- Click Publish.
- In the File name box, type the path and file name that you want.
- Click to select the AutoRepublish every time this workbook is saved check box, and then click Publish.
back to the top
Troubleshooting
You know that AutoRepublish is working if you receive a confirmation message similar to the following the next time that you save the workbook after publishing:
This workbook contains items that are automatically republished to Web pages each time the workbook is saved.
- Disable the AutoRepublish feature while this workbook is open
- Enable the AutoRepublish feature
You may also receive the preceding confirmation message if the workbook that you are saving contains a chart sheet, Microsoft Excel 4 macro sheets, or Microsoft Excel 5 dialog sheets. If you click
Enable the AutoRepublish feature, a warning message appears in a generic Excel warning message box or error message box. The warning states that the workbook contains a chart sheet, Excel 4 macro sheets, or Excel 5 dialog sheets. For more information about the warning and what, if anything, your options are in this case, click
Help on the warning message.
back to the top