How To Find External Links In Excel

Use the “Find and Replace” function in Excel to find external links by searching for the “!http” or “!https” keywords.

External links in Excel can be a powerful tool for referencing data from other workbooks or sheets, allowing for dynamic updates and improved collaboration. However, identifying and managing these external links can often be a time-consuming and manual process. In this blog post, we will explore various techniques and strategies to efficiently locate and manage external links in Excel. Whether you are a beginner or an experienced user, these tips and tricks will help you streamline your workflow and ensure the smooth operation of your Excel spreadsheets. So, let’s dive in and discover how to find and handle those external links with ease!

How To Find External Links In Excel: Step-by-Step


Step 1: Access Excel Interface,

To begin, navigate to the desired location within Excel and locate the file you wish to examine for external links.

Next Step

Step 2: Open ‘Find and Select’ Option,

To access the “Find & Select” feature in Microsoft Office applications, such as Word or Excel, simply go to the “Home” tab. In the “Editing” group, look for the “Find & Select” option. Click on it to reveal a drop-down list of additional search and selection functions for easy navigation and editing.

Next Step

Step 3: Click on ‘Go To Special…’,

To access additional features, select ‘Go To Special…’ from the drop-down list. This will open a dialog box named ‘Go To Special’, offering a range of specialized options for navigating and selecting specific elements within the document.

Next Step

Step 4: Select ‘Formulas’,

Inside the ‘Go To Special’ dialog box, select the ‘Formulas’ radio button to enable checkboxes for different types of links, such as numbers, text, logical, and errors.

Next Step

Step 5: Select All Types,

In the ‘Formulas’ section, you can check all the checkboxes related to numbers, text, logical operations, and error handling to ensure the accuracy and functionality of your formulas.

Next Step

Step 6: Click on ‘OK’,

After selecting ‘OK’ at the bottom of the ‘Go To Special’ tab, Excel will highlight any cells containing external links, allowing for easy identification and management of these linked resources.

Next Step

Step 7: Read Through the Highlighted Cells,

Navigate through the highlighted cells in the spreadsheet to locate external links, typically labeled as [filename]sheetname!cell_reference.

Next Step

Step 8: Edit or Remove External Links,

If you need to edit or remove external links, simply click on the cell containing the link and make the necessary changes in the formula bar.


In conclusion, Excel is a powerful tool that not only allows you to organize and analyze data, but also provides useful features for finding external links. By using the methods outlined in this blog post, you can easily locate and manage all the external references in your Excel workbook. Whether you are collaborating with others or troubleshooting formula errors, having the ability to quickly identify and navigate external links is crucial. So, take advantage of these techniques and make your Excel experience even more efficient and productive. Happy linking!

Table of Contents