Pages

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]
=======================================================

Disable and Enable Excel Automatic Update
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. .

Disable Automatic update in Workbook Excel
  • 6. Click OK to close the Trust Center dialog box.
  • 7. Click OK to close the Excel Options dialog box.

Add
Subscribe in a readerAdd

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.