spot_img

How To Check If An Workbook Is Linked To Another

In this article we will learn how to check if an Excel file is linked to any other External workbook or references.

  1. Lets us start by doing a find by clicking ctrl + F.
  2. Type .xl in the find box.
  3. In the Within box, click Workbook.
  4. In the Look in box, click Formulas.
  5. Click Find All.

find all xl

If there are any external links it will show up like above.

From the location you can go into the respective cells to remove the links. Sometimes the links are in the formulas used in those cells.

Another way to do is by using [ bracket instead of the .xl in the find as follows:

  1. Use Ctrl+F to display the Find dialog (Figure 1).
  2. Type a [ in the Find what box.
  3. Click the Options<< button to expand the dialog.
  4. Make sure the Look in dropdown says Formulas.
  5. Click Find All. It can give the results as follows:

find and replace bracket

Another way is to click the edit links in the Data tab as shown below:

edit links

Then you can click the break links button to break the links to the external sources.

break link

Template

You can download the Template here – Download
spot_img
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell