Disable and Enable Automatic update in Workbook links of External Content section Microsoft Office Excel 2007

=======================================================
To Enable and Disable Automatic Update For Data Connections of Blocked Content of Workbook links in External Content section [Trust Center Setting]
=======================================================


Follow these Steps:

• 1. Click the Microsoft Office Button, and then click Excel Options
• 2. Click Trust Center
• 3. Click Trust Center Settings
• 4. Click External Content

To Enable: Check the Radio Button of The Following..
Prompt user about Data Connections and Prompt user on automatic update for Workbook Links

To Disable Check: Check the Radio Button of The Following..
Disable automatic for Workbook link and Disable all Data connection.

• 5. Click Message Bar.

To Enable: Check the Radio Button of The Following..
Show the Message Bar in All Application when content has been block.

To Disable Check: Check the Radio Button of The Following..
Never Show information about blocked content. .

• 6. Click OK to close the Trust Center dialog box.
• 7. Click OK to close the Excel Options dialog box.

Subscribe in a reader