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.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!
