How can I find the cell in an Excel worksheet that has a link to an external source?

Subscriber Margaret Y. asks “How can I find the cell in an Excel worksheet that has a link to an external source?”

If you link to another workbook in Excel, the link follows the format: path[workbook]sheet!cell.  For example, C:\Users\John Chandler\Documents\Admin\[Expenses] 2015!$C$5

So if you want to find cells that contain links, you can use the Find command to search for [.  It is unlikely [ is used anywhere in the workbook except in links so this provides a very efficient way to locate them.

Note that if you want to edit or delete the links in your workbook you do not need to use Find as Excel maintains a list of all links in the workbook:  On the Data tab, in the Connections group, click on Edit Links.

If you found this useful, let me know [email protected]