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 ....
|