?
Solved

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

Posted on 2013-11-21
4
Medium Priority
?
5,685 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
[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
  • 2
  • 2
4 Comments
 
LVL 19

Accepted Solution

by:
regmigrant earned 1260 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

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!

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

741 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