How to check if an excel sheet has external references.

If you're lucky, you could look through all the formulas looking for .xls or
..xls].

But those links can hide in mysterious places.

I'd get a copy of Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

To see if the code found everything.

Daffo wrote:
>
> Hi everybody, i want to know how to do this. Suppose there is a work
> sheet by name WrkSheet1 in WorkBook1 and there is another work sheet by
> name WrkSheet4 in WorkBook2. WrkSheet1 is linked to WrkSheet4( WrkSheet4
> uses data from WrkSheet1 as input). How do i find out if WrkSheet1 has
> any dependencies or external references. I want to do this
> *Programmatically using VB*.
>
> I apologise if this has already been discussed. If it has already been
> discussed plz let me know as to where i can find it.
>
> With Regards,
> Daffo.
>
> --
> Daffo
> ------------------------------------------------------------------------
> Daffo's Profile: http://www.excelforum.com/member.php...o&userid=37472
> View this thread: http://www.excelforum.com/showthread...hreadid=571337

--

Dave Peterson

You can press Ctrl+~ to display all the formulas in text.Pressing it again
would retrieve the original formulas
In case you have references to an external workbook Excel would prompt you to
resolve external links.Else you can do this by going to Edit->Links and then
following the options for which you may find the following post useful.
http://xlmaster.blogspot.com/2006/08/edit-menu.html

If you want to do this in VBA, then you must do it by checking whether each
cell contains the workbook name

Daffo wrote:
>Hi everybody, i want to know how to do this. Suppose there is a work
>sheet by name WrkSheet1 in WorkBook1 and there is another work sheet by
>name WrkSheet4 in WorkBook2. WrkSheet1 is linked to WrkSheet4( WrkSheet4
>uses data from WrkSheet1 as input). How do i find out if WrkSheet1 has
>any dependencies or external references. I want to do this
>*Programmatically using VB*.
>
>I apologise if this has already been discussed. If it has already been
>discussed plz let me know as to where i can find it.
>
>With Regards,
>Daffo.
>

--
Message posted via http://www.officekb.com