Forum Discussion
Mark Adams
Mar 12, 2018Copper Contributor
Security Warning: Automatic update of links has been disabled.
I'm having an issue clearing a Security Warning in Excel.
When I open Excel, I receive a warning saying:
"Security Warning: Automatic update of links has been disabled."
So, I go to Dat...
- Mar 12, 2018
The other places could be inside Conditional Formatting or in Pivot Tables connected directly to external sources.
I'd suggest you download this add-in created by Excel MVP Bill Manville
http://www.manville.org.uk/software/findlink.htm
Mark Adams
Mar 12, 2018Copper Contributor
Thank you for your reply!
Unfortunately, it hasn't resolved the problem, as Name Manger does not show any references to any external workbooks and I have no Charts in this workbook.
Unfortunately, it hasn't resolved the problem, as Name Manger does not show any references to any external workbooks and I have no Charts in this workbook.
Wyn Hopkins
Mar 12, 2018MVP
The other places could be inside Conditional Formatting or in Pivot Tables connected directly to external sources.
I'd suggest you download this add-in created by Excel MVP Bill Manville
http://www.manville.org.uk/software/findlink.htm
- Mark AdamsMar 14, 2018Copper ContributorThe Add-In worked! It turns out it was a validation formula that was calling the workbook after I copied/pasted from another workbook. Problem solved. Thank you!
- k lApr 26, 2018Copper ContributorI have the same problem. But, FindLink will not find it. I have also been through any other methods of hunting it down, to no avail. Even the "break link" will not work. There seems to be some kind of link that once created, cannot be removed.
- Wyn HopkinsApr 26, 2018MVPHave you tried going to Data > Connections and seeing if there’s anything there ?