When opening my Excel sheet using Excel 2010, I get a yellow bar at the top from Excel informing me that it has de-activated the automatic update of hyperlinks.
To my best knowledge, I do not know that I ever entered a hyperlink.
I have even copy-pasted the content to a new sheet some time back, with no success.
How do I find these hyperlinks, so that I can delete them?
Best Answer
You can deactivate the links through Office button and the Excel options button, see Turn off hyperlinks.
Hyperlinks can be found through the search function, see Finding Excel hyperlinks. Quoting from the source:
The reason the Find Feature works is that external references are identified by a set of brackets. However, the feature also finds whatever left brackets you might have on the document, not just the ones corresponding to external references.