Paste Special Paste Link In #Excel

Here is how to link two workbooks and keep them in sync.

You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.

I have two files I want to keep in sync: Link One.xlsx & Link Two.xlsx. I’ve set up the outline in Link Two to match the layout in Link One:

ps1

One way to link the data from one to the other is to click on the cell we want the linked data to sync to (Link Two cell B3), enter the equal sign (=), then click on the corresponding cell in Link One, and hit enter:

ps2

Notice the structure of the link. The file name is in square brackets [ ] followed by the sheet name and cell reference. Also note that the cell reference is an absolute cell reference, so if you want to copy cell B3 down, you need to change it to a relative cell reference:

ps3

An alternative is to highlight the source cells you want to link to (Link One.xlsx, cells B3:B13), copy those and then, on Link Two, Paste those cells using Paste Link:

ps4

Either way will link the files and keep the data in sync.

Happy Excelling!

Related Post

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

, , , , ,

2 Responses to Paste Special Paste Link In #Excel

  1. Bobby Zopfan March 11, 2017 at 9:13 am #

    Suppose I’ve a formula in (Sheet1) Cell C3: =A1+B1

    I copied it and pasted its link (by Paste Special Dialogue), onto Same sheet’s cell number e3.
    Now what I want that e3 should link to formula (or the dynamic formula itself) in C3, and not the value of C3. And whenever I make a change to the formula in C3, the same should reflect in the e3 as well.

    Is there a way to accomplish this in excel?

Leave a Reply