Linked Workbooks

[D. Bruton]

I have a workbook that is linked to three other workbooks, but I cannot find the cell which contains the link in order to delete the link. Using a copy I deleted all the information (including macros) from the workbook, but still the links remained. Any suggestions on how to "unlink" these workbooks and/or find which cells are linked would be appreciated. Thanks!

[Rutgers_Excels]

What you can do is highlight the entire worksheet and do a Find. When an external file is linked in a cell it looks like this.....


='[File Name.xls]WorksheetName'!$A$1

If you do a Find for the following text....

'[

...you should be able to easily find it.