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]