Mar 11 2018 09:47 PM
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.
Mar 11 2018 09:54 PM
Mar 11 2018 10:01 PM
Mar 11 2018 10:27 PM
SolutionThe 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
Mar 14 2018 12:09 AM
Apr 26 2018 12:16 PM
Apr 26 2018 03:48 PM
Mar 11 2020 03:06 AM
Same problem i am also getting how to resolve@Mark Adams
Mar 11 2018 10:27 PM
SolutionThe 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