Search notes:

Excel: Data -> Queries & Connections -> Edit Links

Update Values
Change Source…
Open Source
Break Link
Check Status

Break Link not working

I once encountered an Excel sheet where another workbook/sheet was referenced but Break Link would not work: although I could click the button and Excel reminded me that «breaking links permanently converts formulas and external references to their existing values», the links were not removed.
I was able to find the cells with the references via File -> Info -> Check for Issues, then choosing Check Compatibility which showed a «summary» of cells that contained data validation rules which referred referred values of the other worksheet.
After using this functionality to select the cells with references, I could remove the validation rules in the immediate window with 
selection.validation.delete

TODO

The updateLinks property of the workbook object can be set to one of the values of the xlUpdateLinks enumeration:
xlUpdateLinksAlways 3
xlUpdateLinksNever 2
xlUpdateLinksUserSetting 1
activeWorkbook.updateLinks = xlUpdateLinksAlways

See also

Apparently, some (or all?) links can be found with VBA using the function workbook.linkSources.

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/Microsof...', 1788604402, '216.73.216.30', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/Microsoft/Office/Excel/GUI/Ribbon/tabs/Data/Queries-and-Connections/Edit-Links/index(70): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78