Identifying External links

[ajm]

does anybody know of a quick and easy way to find links to external workbooks? I can identify that links exist in this workbook, I just don't know which cells they occupy.

 

[Boller]

Select all cells.

Go to Edit>Find

Find what : [

Look in : Formulas

 

[JohnnyTightlips]

further to Boller's suggestion, also check named ranges and source data for Charts, as they can sometimes be hiding therein

 

[ajm]

thanks folks. did pretty much exactly that and got a result - on the very last tab, ofcourse...

Cheers.