Forum Discussion
Solved
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...
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
2 main places to look for these "ghost" links is
a) Formula > Name Manager and look in the Refers to column
b) Charts: Click on the charts and choose Select Data to see if there's external links there
a) Formula > Name Manager and look in the Refers to column
b) Charts: Click on the charts and choose Select Data to see if there's external links there
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.
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
- The 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!
- I 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.
