Solved

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

Posted on 2013-11-21
4
5,194 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

808 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