Ask Leo! by Leo A. Notenboom

How do you link cells in different Workbooks in Excel?

Search First! Then browse: Categories | Full Archive | By Date | Newsletter

Home » Microsoft Office

Summary: You can easily link cells across workbooks in Excel. In fact, Excel itself will do most of the work for you.

How do you link cells in different Workbooks in Excel?

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.

Article C1963 - May 30, 2004

Helpful? Get new articles weekly by email in my FREE newsletter!

Your Name:
Your Email:


Why Subscribe?

Recent Comments
17 Comments

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

Posted by: Neeraj Kumar at March 18, 2008 9:05 PM

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?

Posted by: Gavrick at April 17, 2008 9:13 PM

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

Posted by: ar at May 28, 2008 11:30 AM

hi, thanks alot~! just what i need.

Posted by: liyen at July 29, 2008 9:34 AM

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?

Posted by: shri at October 18, 2008 3:28 AM

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.

Posted by: Dan at December 8, 2008 7:10 PM

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!

Posted by: Jay Clarke at February 4, 2009 7:44 PM

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

Posted by: Muhammad Imaduddin at March 31, 2009 11:18 PM

I want to make a link from one area to another in the same worksheet but in reverse order

Posted by: Daniel Tsvetanov at April 27, 2009 1:10 AM

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

Posted by: greg at September 3, 2009 4:34 PM

Post a comment on "How do you link cells in different Workbooks in Excel?":






(Email Address will not be published.)

Remember Me?

By popular demand...
my tip jar
Cuppa Joe
Buy Leo a Latte!

(you may use HTML tags for style)

RSS feed Subscribe to the RSS Feed specifically for comments on this article.

Before commenting, please...

  • Read the article at the top of this page. If your comment shows you didn't, it'll be deleted and ignored.

  • Comment only on this article. Use the Google search box at the top of the page if you have a question about something else.

  • Don't include personal information in the comment. No email addresses. No phone numbers. No physical addresses.

  • Don't spam. Excessive links to unrelated sites within a comment or across multiple comments will cause all such comments to be removed.

  • Don't ask me to recover lost passwords or hacked accounts. I can't, and those comments will be deleted.

  • I can't respond to every comment. And I can't vouch for the accuracy of others who do.

Please wait. Your comment is being processed ...


Question? Ask Leo!