Mastering Excel Links: From Hyperlinks to Linked Documents

Everything about linking in Excel what you did not know and was too afraid too ask. We will learn how to link different types of objects in Excel, including hyperlinks, documents, objects, and text boxes. We will also learn how to check if an Excel file is linked to another.

First things first. Let’s start from something easy.

How to insert a hyperlink?

Learn how to create hyperlinks in Microsoft Excel effortlessly:

Click on the “INSERT” tab and then click on “Hyperlink”.

add hyperlink

To link to a document on your computer, use the “look in” feature to locate the folder and select the desired document.

insert hyperlink

If linking to a website, simply enter the website’s name in the Address bar.

address

Besides documents, you can also link images, songs, and videos to your Excel file using Hyperlinks. These links will appear in BLUE color.

google hyperlink

How to Link Two Documents

Linking different Excel files to each other is what we will be doing together.

Create two different Excel files.

two files

Open the document, which you want to link another one to.

open first file

Copy and paste the values.

copy and paste

Click under Total, type =B5+C5.

click under total

Double-click on the small square in the cell’s bottom-right corner.

double click small square

In the source document, copy the desired data.

go to second file

Return to the target document.

other document

Right-click on the cell under Price and choose Paste Special.

See also  How to resolve runtime error 9 subscript out of range error

paste special

Select Paste Link.

paste link

By linking documents, changes in one document will instantly update the linked data in the other. This is valuable for efficient reporting in business scenarios.

How to Link Objects

Follow the steps below to learn how to create linked objects in Excel.

Open both Word and Excel document hat contains the data that you want to create a linked object.

In Excel select the range of cells (containing data) or the charts that you want and copy them (CTRL + C)

Next, go to Word and then click where you want the information to appear. On the Home tab click on Paste and select Paste Special. In the As list select Microsoft Office Excel Object.

paste special

Click Paste or Paste Link.

paste object

Click on the Insert tab and then click on Table and then click on Excel Spreadsheet. Fill in the worksheet with the information you want.

Excel spreadsheet

You can also insert an object to your spreadsheet.

To do that just click on insert and then on shapes.

insert ribbon objects

Choose a drawing object.

choose ribbon object

Press and hold the left button on the mouse while moving the mouse to draw the object.

drawing object in Excel

Linking Text Box to a Specific Cell

Here’s how to link a TextBox to a specific Excel cell:

  1. Go to the Insert tab in the ribbon.
  2. Click the Text Box button.
  3. Draw a text box on your worksheet.
  4. Select the text box.
  5. In the Formula Bar, type the address of the cell (e.g., B2).
  6. Your text box will display the content of the linked cell.

B2 cell content

How to check if an workbook is linked to another?

Learn how to check if an Excel file is linked to external workbooks or references:

  1. Use Ctrl + F to open the Find dialog.
  2. Type “.xl” in the Find what box.
  3. In the Within box, select “Workbook”.
  4. In the Look in box, choose “Formulas”.
  5. Click “Find All”.
See also  How to Use the Trapezoidal Rule in Excel

find all xl

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