In order to allow the workbook to connect to the external source you will need to grant it permission.
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.
You can do this by ensuring no other workbooks are open and then searching for , where the asterisk represents a wildcard string.
Excel 97 doesn't provide the option of searching the entire workbook, but you can search all worksheets in a workbook by grouping them. provide the option of searching within the sheet or workbook.
Anyway, I put together a pretty simple spreadsheet where a single cell will reference one other file, very simple.
So I closed out of my work so my boss could review.
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.