Finding links in a spreadsheet

Hi Dee, thanks for your query. Remember that links to cells in the same Workbook will be described as e.g. Sheet2!A1 and links to other workbooks will put square brackets around the filename of the external workbook. So you can use Find to search for these characters:

Use CTRL+F to bring up the Find and Replace dialog box.

Click Options.
In the Find what box, enter ! or [
In the Within box, click Workbook.
In the Look in box, click Formulas.
Click Find All.

Hope this helps,

Anthony