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 Wed, 18 Apr 2018 12:52:20 +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 ....

[Edit:] actually Excel 2003. But as I mentioned, it *should* be
generic.

How to locate cells with links to other cells/worksheets
 

On Wed, 18 Apr 2018 12:52:20 +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 ....

Oh for the times past when a MS MVP would pop in with a solution.

Anybody?

How to locate cells with links to other cells/worksheets
 

On 4/21/2018 8:30 AM, pedro wrote:
....

Oh for the times past when a MS MVP would pop in with a solution.

Anybody?

<https://support.office.com/en-us/article/find-links-external-references-in-a-workbook-fcbf4576-3aab-4029-ba25-54313a532ff1

--

How to locate cells with links to other cells/worksheets
 

On 4/21/2018 11:27 AM, dpb wrote:
On 4/21/2018 8:30 AM, pedro wrote:
...

Oh for the times past when a MS MVP would pop in with a solution.

Anybody?

<https://support.office.com/en-us/article/find-links-external-references-in-a-workbook-fcbf4576-3aab-4029-ba25-54313a532ff1

I've not tried, but I see no reason one couldn't write a user function
to return formulae as string and parse them to automate the process...

--

How to locate cells with links to other cells/worksheets
 

On Sat, 21 Apr 2018 11:27:48 -0500, dpb wrote:

On 4/21/2018 8:30 AM, pedro wrote:
...

Oh for the times past when a MS MVP would pop in with a solution.

Anybody?

<https://support.office.com/en-us/article/find-links-external-references-in-a-workbook-fcbf4576-3aab-4029-ba25-54313a532ff1

Wonderful! Found it like a shot. (Of course, WHY it was there remains
a mystery, but at least the ghost has been dealt with).

Thanks for that link - all my hunting for a solution hadn't discovered
that, and doing a search of the entire file looking for the linked
file name with a search tool was frustrated by the workbook being
encoded of course.

Many thanks.