Helping people with computers... one answer at a time.

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 « »

Share this article with your friends:

Share this article on Facebook Tweet this article Email a link to this article
Leo Leo A. Notenboom has been playing with computers since he was required to take a programming class in 1976. An 18 year career as a programmer at Microsoft soon followed. After "retiring" in 2001, Leo started Ask Leo! in 2003 as a place for answers to common computer and technical questions. More about Leo.

Not what you needed?

27 Comments
Carson
September 30, 2004 5:11 PM

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

SUNDARA MURTHY
August 24, 2005 4:35 AM

please help me

how to create Paste Link in the excel using vba code

regards,
SUNDER

Tom
September 28, 2006 9:39 AM

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

Bob Whiton
March 10, 2007 6:50 PM

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.

andrew
March 14, 2008 10:47 AM

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?

Neeraj
March 16, 2008 3:09 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

michelle
March 17, 2008 1:02 PM

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

Neeraj Kumar
March 18, 2008 9:05 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

Gavrick
April 17, 2008 9:13 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?

ar
May 28, 2008 11:30 AM

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

liyen
July 29, 2008 9:34 AM

hi, thanks alot~! just what i need.

shri
October 18, 2008 3:28 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?

Dan
December 8, 2008 7:10 PM

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.

Jay Clarke
February 4, 2009 7:44 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!

Muhammad Imaduddin
March 31, 2009 11:18 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

Daniel Tsvetanov
April 27, 2009 1:10 AM

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

greg
September 3, 2009 4:34 PM

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

David
March 16, 2010 2:20 AM

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

Lewis Mulhollen
July 14, 2010 9:22 AM

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?

Sudhakar M
December 20, 2010 1:16 AM

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

Elvir
March 30, 2011 1:22 PM

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

Helen Goy
August 2, 2011 5:15 PM

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

Chris
September 30, 2011 11:51 PM

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

Nguyen Dinh Hoa
November 17, 2011 6:44 PM

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

Bharathi
December 15, 2011 10:25 PM

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.

Phil
December 27, 2011 4:23 AM

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.

windy
February 7, 2012 9:01 PM

why the link destination worksheet was break after I added a new row at the middle of the row ?

Comments on this entry are closed.

If you have a question, start by using the search box up at the top of the page - there's a very good chance that your question has already been answered on Ask Leo!.

If you don't find your answer, head out to http://askleo.com/ask to ask your question.