?
Solved

Excel 2007 Setting

Posted on 2014-01-02
8
Medium Priority
?
241 Views
Last Modified: 2014-01-10
How do you turn on this setting on and off?  
"Security Warning Automatic update of links has been disabled"
ExcelOptions-Settings-MSExcel200.doc
0
Comment
Question by:ca1358
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 23

Expert Comment

by:NBVC
ID: 39752406
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
 

Author Comment

by:ca1358
ID: 39752454
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
 
LVL 23

Expert Comment

by:NBVC
ID: 39752473
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
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 

Author Comment

by:ca1358
ID: 39752493
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
 
LVL 23

Expert Comment

by:NBVC
ID: 39752525
Did you compare the settings in the Trust Center Settings section?  Are they the same in yours and your colleague's?
0
 

Author Comment

by:ca1358
ID: 39752536
Yes
0
 
LVL 23

Accepted Solution

by:
NBVC earned 2000 total points
ID: 39752553
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
 

Author Closing Comment

by:ca1358
ID: 39772441
Thank you!
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question