Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 252
  • Last Modified:

Excel 2007 Setting

How do you turn on this setting on and off?  
"Security Warning Automatic update of links has been disabled"
ExcelOptions-Settings-MSExcel200.doc
0
ca1358
Asked:
ca1358
  • 4
  • 4
1 Solution
 
NBVCCommented:
Go to File (or Office button in 2007).

then Excel Options.  Then on left side, select Trust Center.  Then click Trust Center Settings button.  Pick External Content from the left side, then select either Enable Automatic updates for all Workbook Links (which is not recommended)... or select Prompt User on automatic update for Workbook links.
0
 
ca1358Author Commented:
I have that setting on my computer and it works, it shows "Security Warning Automatic update of links has been disabled" which I dont how I got it,
  but we tried it on my co-workers and it doesn't just gives this message which  Included Screen Print.
This-Workbook-contains-one-or-mo.doc
0
 
NBVCCommented:
You will need to click Edit Links and re-direct the links to where the source files are.  It appears that perhaps the source file was deleted or moved.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
ca1358Author Commented:
I should have explained, the File we our opening is the same file, and I do not get that message but she does and that Security Warning message shows on mine but not hers.   We our connected to the same Source Network Drive.   So I thought it would have to be some Excel Setting.
0
 
NBVCCommented:
Did you compare the settings in the Trust Center Settings section?  Are they the same in yours and your colleague's?
0
 
ca1358Author Commented:
Yes
0
 
NBVCCommented:
Try looking at the Names Manager (Formulas Tab) to see if there are Named Ranges that are not correct, referencing workbooks that don't exist or plain shouldn't exist.
0
 
ca1358Author Commented:
Thank you!
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now