Você pode desativar os links através do botão Office e do botão de opções do Excel, veja Desligue os hiperlinks .
Os hiperlinks podem ser encontrados por meio da função de pesquisa, consulte Localizando hiperlinks do Excel . Citando a partir da fonte:
Using the Find Feature
A quick way to cycle through your external links (depending on the number you have) is to use the find feature built into Excel. We will be searching for “[“, left bracket, which can help identity those external workbook references.
- Hit Ctrl+F (or Edit–>Find on your toolbar) on your keyboard to open your find wizard
- Click the “Options” button to open additional criteria
- Select: within “Workbook”
- Select: look in “Formulas”
- Finally, enter a left bracket “[” in the Find What field (without double quotes)
That’s it. Excel will now go through and show you all the instances where the left bracket has been used in your spreadsheet, which should identify external references to other spreadsheets.
Delete Links Add-In
Microsoft has also provided an add-in to help you identify and delete links. To view Microsoft’s solution to this problem, visit http://support.microsoft.com/default.aspx?kbid=188449. There is an additional Read-me file to help you use the add-in after you extract from the exe file.
A razão pela qual o recurso Find funciona é que as referências externas são identificadas por um conjunto de colchetes. No entanto, o recurso também encontra os colchetes que você pode ter no documento, não apenas aqueles correspondentes a referências externas.