Ask Leo!

How do you link cells in different Workbooks in Excel?

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.

More articles about: Microsoft Office

Article Useful? Link to it from your own website; just copy/paste this HTML:

Article 221 | Posted May 30, 2004

Recent Comments

please help me

how to create Paste Link in the excel using vba code

regards,
SUNDER

Posted by: SUNDARA MURTHY at August 24, 2005 04:35 AM

How do I link multiple cells, from several worksheets, to one cell in my summary worksheet, in Excel 2002.

Posted by: Tom at September 28, 2006 09:39 AM

Using links between workbooks is known to be problamatic. You might look into LinkedCells at www.LinkedCells.com. It offers a very simple add-in that lets you share your Excel data with others in a publish/subscribe manner.

Posted by: Bob Whiton at March 10, 2007 06:50 PM

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?

Posted by: andrew at March 14, 2008 10:47 AM

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

Posted by: Neeraj at March 16, 2008 03:09 AM

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!!!

Posted by: michelle at March 17, 2008 01:02 PM

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 09: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 09: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 09:34 AM

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)

New!

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

Before commenting, please...

Please wait. Your comment is being processed ...


Ask Your Question:


ask-leo.com
Web

Archives

By Category
By Date

Advertisers

Advertise on Ask Leo!

««   »»

Question? - Ask Leo!
Who is Leo?
Link to Leo!

Terms, Conditions & Privacy