Ask Leo! by Leo A. Notenboom

How do you link cells in different Workbooks in Excel?

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

Ask Leo! » Microsoft Office

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

by , © 2004

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

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?

Recent Comments
27 Comments

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

Posted by: Chris at September 30, 2011 11:51 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

Posted by: Nguyen Dinh Hoa at November 17, 2011 6:44 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.

Posted by: Bharathi at December 15, 2011 10:25 PM

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.

Posted by: Phil at December 27, 2011 4:23 AM

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

Posted by: windy at February 7, 2012 9:01 PM
See all 27 comments...
Post a comment on "How do you link cells in different Workbooks in Excel?":





Remember Me?

(You may use HTML tags for style)

Before commenting, please...

  • READ THE ARTICLE. A comment that shows you didn't will be deleted and ignored.

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

  • NO PERSONAL INFORMATION in the comment. No email addresses. No phone numbers. No physical addresses.

  • Anything that looks the least bit like spam will be deleted. Links to unrelated sites or links that appear to be primarily promotional will be deleted, or the comment will be deleted.

  • Don't ask me to recover lost passwords or hacked accounts. I can't. 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!
The Tip Jar: Buy Leo a Latte!

Categories | Full Archive
By Date | Business Card | About

Advertisements do not imply my endorsement of any product or service.

Copyright © 2003-2012 Puget Sound Software, LLC and Leo A. Notenboom
Ask Leo! is a registered trademark ® of Puget Sound Software, LLC
Terms, Conditions & Privacy
Product Reviews, Recommendations and Affiliate Links Disclosure

http://ask-leo.com/how_do_you_link_cells_in_different_workbooks_in_excel.html