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