Technology in terms you understand. Sign up for the Confident Computing newsletter for weekly solutions to make your life easier. Click here and get The Ask Leo! Guide to Staying Safe on the Internet — FREE Edition as my thank you for subscribing!

How do you link cells in different Workbooks in Excel?

How do you link cells in different Workbooks in Excel?

[/al_question]

The Paste Link command is probably what you want.

Select the item you want to copy in one workbook and select Edit, Copy. Now in the other workbook, select the desired destination, and hit Edit, Paste Special, and press the Paste Link button.

If you take a look at the resulting formula it should include the filename, sheet name, and cell reference to original data.

Subscribe to Confident Computing! Tech problem solving & safety tips & a weekly confidence boost in your inbox every week.

I'll see you there!

10 Reasons Your Computer is Slow

Slow Computer?

Speed up with my special report: 10 Reasons Your Computer is Slow, now updated for Windows 10.

NOW: name your own price! You decide how much to pay -- and yes, that means you can get this report completely free if you so choose. Get your copy now!

27 comments on “How do you link cells in different Workbooks in Excel?”

  1. Hi am a newbie to VBA here, and just try to create a little payroll system. my aim is when a employee hrs is enter via form it would load the relvant book do calculation of i.e (hrs*Rate) and return it (Value)and display in on a form. looking for your help.

    thankz

    Reply
  2. I am trying to link many workbooks to a single workbook. These workbooks are identical but in separate folders. When I copy and paste the template to the different folders, the path of the centrally linked workbook changes to match the path of the pasted templates. I want to keep this centrally linked workbook in a single location. How do I essentially freeze that path?

    Reply
  3. please help me

    how to create Link from a cell in different worksheet excel using vba code or function.

    I want to know that, there are more than sheet from Month Name such as Jan 08, feb 08,, I want to do that In report cell, when i do entry in a cell of this Sheet name, then it show full data of those Sheet.

    regards,
    NEERAJ KUMAR

    Reply
  4. I want to link a cell in one worksheet to a cell in another so that when I update one, it updates the other automatically. This is not http links, just a link that keeps all linked cells identical. HELP!!!

    Reply
  5. please help me

    how to create Link from a cell in different worksheet excel using vba code or function.

    I want to know that, there are more than sheet from Month Name such as Jan 08, feb 08, I want to do that In report cell Entry the Data and it goes into different sheet.

    regards,
    NEERAJ KUMAR

    Reply
  6. Okay, so I tested the “Paste Special” option and it works!
    I’m trying to create one spreadsheet where I enter data on a daily basis, but I only want to enter this data in one row.
    I would like to link another workbook to this spreasheet that keeps historical data.
    In other words, when I enter numbers into “Spreadsheet A” on Day One that same info will appear in “Spreadsheet B”, Day One.
    On Day Two I will write over the info from the previous day on “Spreadsheet A” and that info will appear in “Spreadsheet B” on the next row for Day Two, and so on.
    Does this require an “If,And” condition?

    Reply
  7. i have ten worksheets. each work sheet has 10 different peoples name adress age phone numbers. I have one summary worksheet as well. i need a formula to find oldest person’s name age and address from each worksheet and automically put into summary sheet. Please advice.
    Thanks

    Reply
  8. There are 5 tables for five different conditions.
    I want to get a value which will be extracted after checking for all five conditions.How to create formula?

    Reply
  9. i want to:
    enter data into ONE cell, and when i do so, 3 different cells mirror the data –

    example: i type ‘8989’ into B13. As i type this, ‘8989’ appears in B14,B15, and B16. When i change the data in any of these cells, it changes also in the others.

    any clue how to do this?
    cheers.

    Reply
  10. I’m linking data on one worksheet to another in the same workbook. When I alter the worksheet where the original data is entered (ie: sort based on changing numbers such as sales per representative), it alters the linked data in the other worksheet ie: the sales rep names are now no longer aligned with the correct sales numbers. I’ve used a function utilizing $ $ to bracket the destination cells so that I can sort that page but the original source worksheet cannot be sorted with out messing up the data on the linked worksheet. How do I keep that from happening? Thanks!

    Reply
  11. Dear Sir,

    I would like to learn a to z about link command in excel

    would you please help me in this regard

    thanks & regards,
    m.imad

    Reply
  12. Is it possible to use relative pathing to link two workbooks in the same directory?

    ‘.\[book1.xls]sheet1’!$a$1
    instead of c:\temp\[book1.xls]sheet1′!$a$1

    I need to send several link workbooks to someone who is on a different file server
    Thanks

    Reply
  13. Hi,

    I have built a “master database” which houses everyone who works for my company. The data is broken down so employees are grouped together by the branch they work at. I have also created a secondary database that is unique to the individual and not the branch. For example, the master database shows everyone who works at Location A, Location B, Location C etc and from that Person A at Location A has their own workbook linked back to the master database (EG A2). This means if i alter, for example person A’s contact number in the master database, his personal file will automatically update. My problem is that if someone joins my company at Location A, once i “insert” a new row to house the new persons data, Person A’s individual link now picks up whatever is in A2 and is not locked into the data assigned to Person A. How can i secure or lock this link so if i need to add people to the master database, all of my satellite databases for each individual is not thrown off by any new arrival?

    Thanks

    Reply
  14. Can you help me figure out how to set up a Excel spreadsheet (source) so that it looks at selected cells in another Excel spreadsheet (target) and will update the cells when they are changed?

    The source file is located at: \\Cmdnas01\HSC_SOLAR\Warehousing\Storage Logistics\Solar Warehousing S4 072509.xls

    The target file is located at: \\Cmdnas01\HSC_DPHOST\Engineering\Reliability\Spares\S98 & St Charles Warehouses – Critical Spare Equipment List.xls

    Note that there is a security warning at the top of the spreadsheet (see screen dump below) that the “automatic update of links has been disabled”. When I try to enable it all the cells lose their links?

    Reply
  15. I have a Excel documnet in the Sheet 1 Major Headings and Sheet 2 Splitings for Major Headings.

    I want a solutions that when ever i want to see Splitings for Major Headings, i will click on beside Major heading cell and it will go to Sheet 2 Splitings for Major Headings.

    Kindly hepl me.

    Thanks-Sudhakar

    Reply
  16. How to make this?
    If text (Sheet1) inside of A1 fild is same as one of the names of sheets (Sheet1) than take info from that sheet (Sheet1) and from fild A2

    Reply
  17. Hi, I have 2 work sheets. On sheet 1 is a list of employees names, phone number, addresses etc and on sheet 2 is the same list but a printable version. What i need to do is say a phone number changes, rather than go to both sheets and type the phone number again, I want to link heet one – type the change and sheet 2 changes automatically. How ????

    Reply
  18. How do I reference a cell (like A1) in the source worksheet, on the server mdnas01:

    \\Cmdnas01\HSC_SOLAR\Warehousing\Storage Logistics\Solar Warehousing S4 072509.xls

    I have mapped server ISD$ to “J”, and when I use “J” I am OK, but when I use the server name “ISD$”, I am getng an error on:

    =\\isd\isd$\ACC-ISD\CBAD\Team-Weekly-Updates\Testing Apps and STATUS\BHART – Test Case Matrix.xls\[‘V15+W7,IE8,O2010]’!K37

    Could you help me?

    Thanks

    Reply
  19. Dear Sir,

    I want to link some rows but larger than one page in microsoft word, so can not see some rows in the sheet.
    Can you help me?
    Many thanks

    Reply
  20. Hi sir,I want to prepare a excel work sheet 1 with multiple rows & columns,I want the updates on other work sheet for month wise automatically when it is updated on work sheet 1.Send me visual format only for excel work sheet.

    Reply
  21. I have made a list of contacts (friends etc) in excel. Is there a way to have their phone number so I can just touch it to dial? Thank you in advance.

    Reply

Leave a reply:

Before commenting please:

  • Read the article.
  • Comment on the article.
  • No personal information.
  • No spam.

Comments violating those rules will be removed. Comments that don't add value will be removed, including off-topic or content-free comments, or comments that look even a little bit like spam. All comments containing links and certain keywords will be moderated before publication.

I want comments to be valuable for everyone, including those who come later and take the time to read.