How to check if an excel sheet has external references.

[Daffo]

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.

 

[Dave Peterson]

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.

 

[prabhuraaman via OfficeKB.com]

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]

Hi thank you for replying. I will try out what you have mentioned and
get back .