Saturday, May 13, 2017
Disable and Enable Automatic update in Workbook links of External Content section Microsoft Office Excel 2007
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
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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.