LInks in Excel

Gambler

I currently have a file which when I select edit then links it shows me a list of files it is linked to.

Anybody know how I can work out which cells contain the links please?

CIS

This link may help, especially the last poast

http://www.mrexcel.com/archive/Edit/19024.html

Chippy_Minton

From Excel help:

Find links in a workbook
There is no automatic way to find links used in a workbook. However, because links use brackets [ ] to enclose the source workbook name when it is closed, you can search for it. For example =SUM([Budget.xls]Annual!C10:C25).

Close all workbooks except the one you want to find the links in.
On the Edit menu, click Find.
Click Options.
In the Find what box, enter [.
In the Within box, click Workbook.
In the Look In box, click Formulas.
Click Find All.
In the box at the bottom, look in the Formula column for formulas that contain [.
To select the cell with a link, select the row in the box at the bottom.

Or download Findlink.xla from http://www.oaltd.co.uk/MVP/Default.htm