Ask a Question

Excel: Find links - this is how it works

+3 votes
85 views
in Office by (242k points)
reopened
Excel: Find links - this is how it works

1 Answer

+4 votes
by (1.6m points)
 
Best answer

How to find links in Excel
1st step:
2nd step:
3rd step:
quick start Guide

Sometimes Excel workbooks contain links that are not obviously recognizable. We'll show you how to find them..

image image

Different workbooks can be linked to one another using links in Excel. Sometimes Excel tells you that your table contains shortcuts or links that cannot be found directly. In this tipps + tricks article, we will show you a method to facilitate the search for the unknown shortcut.

How to find links in Excel

To find links in Excel that link to another file using a formula, the normal search function only needs to be adjusted a little. Follow our step-by-step instructions or take a look at the brief instructions .

1st step:

image
Open the Excel document that refers to another file or contains a link. Use the key combination [Ctrl] + [F] to open " Find and Replace ".

2nd step:

image
Enter the file format " .xl " in the " Search for " field . Set " Browse " to " Workbook " and " Search In " to " Formulas ". Then click on " Find All ".

3rd step:

image
If other files are linked to your current Excel document, they will now be displayed - including the formula and storage location of the external file. The cell of the open table is also shown here

quick start Guide

  1. In the open Excel document, press the key combination [Ctrl] + [F] to open " Find and Replace ".
  2. Enter " .xl " in the search field .
  3. Then choose to " Browse " option " Workbook " and " Search the" Option " formula of".
  4. Then click on " Find all " to display the links.
...