Excel Guides

Finding Unknown Links in Excel

When it comes to finding unknown links in Excel, there are a few different methods that you can use. Each has its own set of pros and cons, so it's important to choose the one that's right for your needs. Here's a look at a few different methods:

1. The Find Function

The Find function is probably the simplest way to find unknown links in Excel. All you need to do is select the cells that you want to search, then click the "Find & Select" button on the Home tab. In the "Find & Select" dialog box, click "Go To Special." In the "Go To Special" dialog box, select "Objects" and click "OK." This will select all of the objects in the selected cells, which will include any linked objects. You can then click the "Edit Links" button on the ribbon to view and manage the links.

2. The Macro Recorder

Another way to find unknown links in Excel is to use the macro recorder. This method is a bit more complex than using the Find function, but it can be helpful if you need to find links in a large number of cells. To use this method, open the Visual Basic Editor (you can do this by pressing Alt+F11). Then, click "Record Macro" on the toolbar. The macro recorder will start recording your actions. Next, select the cells that you want to search and press Ctrl+F11 to open the "Find & Select" dialog box. In the dialog box, select "Objects" and click "OK." This will select all of the objects in the selected cells, which will include any linked objects. You can then click the "Edit Links" button on the ribbon to view and manage the links.

3. The Object Browser

The Object Browser is another tool that can be used to find unknown links in Excel. To use this method, open the Visual Basic Editor (you can do this by pressing Alt+F11). Then, click "View" on the menu bar and select "Object Browser." In the Object Browser, expand Microsoft Excel Objects and double-click _Workbook (this is an underscore followed by Workbook). This will open a list of all of the objects in the workbook. Scroll down until you find LinkedObjects and double-click it. This will open a list of all of the linked objects in the workbook.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.