link to another workbook

  • Thread starter Thread starter Sox
  • Start date Start date
S

Sox

I have a workbook linked to several others. When it starts it asked if the
links should be undated. When yes is selected the first link is to a
workbook belonging to someone else. I have searched for this particular link
to delete or change it but vannot find any formula in the workbook that
referes to this link.
How can I find where this link is set up please?
TIA
Sox
 
I found an add-on which finds links. The links were in 'Names'. I have
deleted them now but I still couldn't find which cell they were in? How
could I have found them without an add-on pls?
Sox
 
You could have looked in formulas for .xls, looked in insert>names, looked
in charts. If you ever want to delete names you could use this macro.

Sub DeleteAllNames()
For Each Name In Names
Name.Delete
Next Name
End Sub

Heres one to delete hyperlinks
Sub HyperlinksOut()
ActiveSheet.Hyperlinks.Delete
End Sub
 
Sox

One method to find links to other workbooks which are embedded in cells is to
do an Edit>Find on "["(no quotes).

A link to another workbook will look like =[otherbook.xls]Sheet1!$A$1 or
similar.

The links to Named Ranges referring to other workbooks can be found in
Insert>Names>Define. Click on each Name and see what it "refers to".

Gord Dibben Excel MVP
 
Back
Top