Thread: Linked Workbooks/Sheets

Hi,
Would be greatfull if someone can help.

I have a large work book with severals limked workbooks attached to it. I
can see the names of all the linked workbooks by going to the Edit-->Links
menu command.
I need to find out exactly how the sheet I am intrsted in(the source sheet)
to this destination sheet--i.e which coulmns in the Destination wokbook is
linked to coulmns in the Source work book.
The destination workbook contains numerous cells with links, fomulas in
them, so going to each cell and looking at the Formula bar for the link is
not an option...
Thanks
Raj

You can toggle between viewing cell values and cell formulas by pressing Ctrl
+ ` (grave accent).

"RAJ" wrote:

> Hi,
> Would be greatfull if someone can help.
>
> I have a large work book with severals limked workbooks attached to it. I
> can see the names of all the linked workbooks by going to the Edit-->Links
> menu command.
> I need to find out exactly how the sheet I am intrsted in(the source sheet)
> to this destination sheet--i.e which coulmns in the Destination wokbook is
> linked to coulmns in the Source work book.
> The destination workbook contains numerous cells with links, fomulas in
> them, so going to each cell and looking at the Formula bar for the link is
> not an option...
> Thanks
> Raj