• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6225
  • Last Modified:

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

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
sglee
Asked:
sglee
  • 2
  • 2
1 Solution
 
regmigrantCommented:
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
 
sgleeAuthor Commented:
Existing ConnectionsThis is what comes up when I go to Data tab and click "Existing Connections".
0
 
sgleeAuthor Commented:
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
 
regmigrantCommented:
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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

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