You do this by right-clicking any Sheet Name tab and choosing Select All Sheets. Once you find the formula links, simply change the formula accordingly or delete it altogether.Whether you change the formula or delete it depends on the situation, and only you can decide which route to take.However, in our experience, it does not find phantom links.
External excel links not updating
In order to allow the workbook to connect to the external source you will need to grant it permission.
For more information about external links, please see the article below: In this method you will grant permission for all files to connect to an external source without warning.
To do this, we like to start from within the Excel workbook containing the phantom links. Scroll through the list of names, clicking to highlight each one and looking in the Refers To: box at the bottom.
Check to make sure none of these names is referencing a different workbook.
I tried a couple of things - "Formulas - Automatic" was checked, clicking "Calculate Now" and "Calculate Sheet" would not update the model.
The only way the to update the cell is to click on the formula and hit Enter or Tab.
I tested the issue out on a couple of new speedsheets (both saved on the same shared drive) and it's still happening.
Not sure if its just my computer yet, currently testing the issue with different computers.
External links are links that reference another workbook.
Unexpected external linking can occur for various reasons, many of them stemming from moving or copying charts, chart sheets, or worksheets into another workbook.
You also might want to consider going to the Microsoft Office Download Center, located at , and from the Add-Ins category selecting the Delete Links Wizard.