Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
LIVE
SOLVED

Searching for external links in excel workbook

Copper Contributor

I found there is a link to helping with this already (see below) however when following the same process it just says "We couldn't find what you were looking for. Click Options for more ways to search"

Link - (https://support.microsoft.com/en-us/office/find-links-external-references-in-a-workbook-fcbf4576-3aa....)

2 Replies
best response confirmed by TFS1990 (Copper Contributor)
Solution

@TFS1990 

To search for external links in an Excel workbook, you can use the "Edit Links" feature. Here are the steps:

  1. Open the Excel workbook that you want to search for external links.
  2. Go to the "Data" tab in the Excel ribbon, and click on "Edit Links" in the "Connections" group.
  3. The "Edit Links" dialog box will open, which shows all the linked workbooks that are used in the current workbook. This dialog box will show you all the external links as well as the internal links.
  4. To see only the external links, click on the "Status" column heading to sort the links by status. External links will have a status of "Source not found" or "Error".
  5. If you want to update or change an external link, select it and click on the "Change Source" button.
  6. If you want to break an external link, select it and click on the "Break Link" button.

By following these steps, you can easily search for external links in your Excel workbook and manage them as needed.

 

About your link:

You can find external links in an Excel workbook by using the Find and Replace feature.

Here are the steps to do so:

  1. Select all the cells in your workbook.
  2. Go to the Home tab –> Editing –> Find & Select –> Find.
  3. In the Find and Replace dialog box, enter *.xl* in the ‘Find what’ field.
  4. Click on Find All.

This will find and show all the cells that have external links in them.

 

Hope it helps you!

@NikolinoDE thank you very much....that worked!

1 best response

Accepted Solutions
best response confirmed by TFS1990 (Copper Contributor)
Solution

@TFS1990 

To search for external links in an Excel workbook, you can use the "Edit Links" feature. Here are the steps:

  1. Open the Excel workbook that you want to search for external links.
  2. Go to the "Data" tab in the Excel ribbon, and click on "Edit Links" in the "Connections" group.
  3. The "Edit Links" dialog box will open, which shows all the linked workbooks that are used in the current workbook. This dialog box will show you all the external links as well as the internal links.
  4. To see only the external links, click on the "Status" column heading to sort the links by status. External links will have a status of "Source not found" or "Error".
  5. If you want to update or change an external link, select it and click on the "Change Source" button.
  6. If you want to break an external link, select it and click on the "Break Link" button.

By following these steps, you can easily search for external links in your Excel workbook and manage them as needed.

 

About your link:

You can find external links in an Excel workbook by using the Find and Replace feature.

Here are the steps to do so:

  1. Select all the cells in your workbook.
  2. Go to the Home tab –> Editing –> Find & Select –> Find.
  3. In the Find and Replace dialog box, enter *.xl* in the ‘Find what’ field.
  4. Click on Find All.

This will find and show all the cells that have external links in them.

 

Hope it helps you!

View solution in original post