Forum Discussion
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 Data >> Edit Links and find that there's a reference to "<filename>.xlsb", and the Document Inspector confirms that there are links in the file.
Then, I search in the formulas for the whole workbook, and Find/Replace finds nothing with that file name or extension. I have even tried Break Links and, after saving and reopening the file, the issue persisted.
How can I find the links that are causing this annoying warning to appear?
Suggestion: Edit Links should include a "Go to..." function.
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
7 Replies
Same problem i am also getting how to resolveMark Adams
- 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- 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
