View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pedro pedro is offline
external usenet poster
 
Posts: 14
Default 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?