Detect Links within a workbook

[Mindpsyche]

Hello,

I have a workbook with a few worksheets. In sheet1 I have a few ranges which are linked to different parts in the other excel sheets.

Is there anyway to check if a range is being used as a link in another sheet.

Eg.

In sheet1 , A1 i have a value Apple.

In sheet2, A1 I have linked it to sheet1 A1.

So my question is, is it possible to detect the link in sheet2 A1 from Sheet1 A1? I tried using Trace dependents but all it shows me is the link symbol? An arrow with a small excel sheet.

Thanks for any help.

 

[Mindpsyche]

Bump