Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 .... |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 -- |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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... -- |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to locate cells with links to other cells/worksheets | Excel Discussion (Misc queries) | |||
How do I locate cells that contain a certain text? | Excel Worksheet Functions | |||
Locate the Cells with the Formula and External Links | Excel Discussion (Misc queries) | |||
How do I locate merged cells | Excel Discussion (Misc queries) | |||
Update Links between cells of two worksheets in the same workbook | Excel Discussion (Misc queries) |