About enabling and disabling the AutoRepublish feature

Microsoft Office Excel 2003

previous page next page
  • When you have entered confidential or sensitive information that should not be published to a public location
  • When you're temporarily disconnected from a network or Web server location
  • When you're saving a workbook that was created by someone who is not a trusted source (the workbook could contain macros that collect information from a network location using your credentials, and then publish that information to a public location)

    • You can disable AutoRepublish temporarily (for the current open and close session) or permanently (every time you open, save and close). Or you can continue to AutoRepublish.

    ShowDisable AutoRepublish temporarily

    1. When you save a workbook and have AutoRepublish enabled, a message will appear. Make sure to select the Disable the AutoRepublish feature while this workbook is open option.
    2. Click OK.

      AutoRepublish is disabled for the current session of the workbook only, or until you close the workbook. The next time you open the workbook, AutoRepublish will be enabled.

    ShowDisable AutoRepublish permanently

    1. Open the workbook that is set to automatically republish.
    2. On the File menu, click Save as Web Page.
    3. Click Publish.
    4. In the Choose list, click Previously published items.
    5. Select the item that you want to discontinue republishing automatically, and click Remove. Repeat for each item you don't want to automatically republish.
    6. Click Close.
    7. Click Save on the File menu to save the change to your workbook.

    ShowContinue with AutoRepublish

    • Click Enable the AutoRepublish feature in the message that is displayed each time you save the workbook.

      Note  

      • You can tell that a workbook is set to AutoRepublish when you see Publishing to Page: filename in the status bar during a save.
    previous page start next page