Solved

Security Warning in EXCEL - Automatic update of links has been disabled

Posted on 2013-11-21
4
4,905 Views
Last Modified: 2013-11-26
EXCEL WarningMacro Settings
Hi,
  I have an EXCEL 2010 file that displays a warning like seen above when I open it.
  It does not have any macros nor it is linked to any sheet or any other excel file.
   
 Can you help?
0
Comment
Question by:sglee
  • 2
  • 2
4 Comments
 
LVL 19

Accepted Solution

by:
regmigrant earned 315 total points
ID: 39668508
This is not a Macro warning so the trust centre setting is not relevant.

On the DATA tab look at 'connections' and 'edit links' to see if there is an embedded query or link

Reg
0
 

Author Comment

by:sglee
ID: 39670185
Existing ConnectionsThis is what comes up when I go to Data tab and click "Existing Connections".
0
 

Author Comment

by:sglee
ID: 39670216
Link Warning Edit Links 1Edit Links 2This time I tried to open in EXCEL 2003 (Office 2007 compatibility installed) and got the warning message "This workbooks contains links to other data sources. When I clicked [Update], then I got another warning popup window "This workbooks contains one or more links that cannot be updated.". When I clicked [Edit Links], I saw "Edit Links" windows with different file name located off C:\Company Shared Folders\xxx\xxx\Week3.
0
 
LVL 19

Expert Comment

by:regmigrant
ID: 39676931
Glad you got it resolved, if you can recreate the problem (I only have 2013) I would file a bug reports with MS - it looks like there is a potential for some linked data to be missed in compatibility mode

Reg
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

757 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now