How to locate cells with links to other cells/worksheets
 

I have a workbook with about a dozen worksheets. This is the annual
version of a long-running series used in relation to tax returns.

Suddenly, the file locations in a couple of links to cells in other
workbooks have become corrupted. Those are easy enough to "repair"
(although the reason remains unknown) but at the same time there is a
link in the 2016/17 file to the 2008/09 workbook.

Now there is simply no reason for such a link to exist, but Excel
seems to offer no way to find out which sheet/cell in the current book
contains that link/reference. Edit-Links allows me to see all such
links, but nowhere does it provide the location of the link call.

Am I missing something?

Although this should be a generic Excel question (and answer), the
version in use is Excel 97 ....

How to locate cells with links to other cells/worksheets
 

On Thu, 18 Jan 2018 15:10:56 +0800, pedro wrote:

I have a workbook with about a dozen worksheets. This is the annual
version of a long-running series used in relation to tax returns.

Suddenly, the file locations in a couple of links to cells in other
workbooks have become corrupted. Those are easy enough to "repair"
(although the reason remains unknown) but at the same time there is a
link in the 2016/17 file to the 2008/09 workbook.

Now there is simply no reason for such a link to exist, but Excel
seems to offer no way to find out which sheet/cell in the current book
contains that link/reference. Edit-Links allows me to see all such
links, but nowhere does it provide the location of the link call.

Am I missing something?

Although this should be a generic Excel question (and answer), the
version in use is Excel 97 ....

Bump. See above. The problem is that there *may be* an orphaned link
somewhere.

Edit-Links allows me to see all such links, but nowhere does it
provide the LOCATION of the link call.

Anyone?