Opening a Linked Workbook in Microsoft Excel 2010

In this article, we will learn how to open a linked workbook; the source link allows to open the source link in Microsoft Excel 2010.

Let’s take an example and understand how you can change the source link.

Example 1: We have data in range A1: E9, which is linked with another workbook. To open the source link, follow below mention steps: -

  • Select the cell A2 and press the key “CTRL+Shift+Down key (arrow) +Right Key (arrow) to select the data.
  • Go to “DATA” tab in the group of “CONNECTIONS”, and select “EDIT LINKS”.
  • The dialog box of “Edit Links” will get appeared.
  • To change the source of link, click on the button of “Change Source” in right side.
  • When you click on “Open Source” then you can choose another file.
  • Click on OK.


  • Source file will get open when you will do any changes in the source file, and main file will get update automatically.

This is the way we can open a linked workbook in Microsoft Excel.


Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.