I have data in another workbook that I want to pull into my current workbook. How do I do this?


The easiest way to accomplish this is to open both workbooks. In the workbook you want to pull the data to, enter =, then go to the workbook you are pulling from and select the cell you would like to pull over.

Alternatively, you can simply type the formula which is:
=’[Source Workbook Name.xls]SheetName’!$A$1

You will get a message when you open your workbook stating that there is data linked ot other datasources. Be forewarned…Problems can (and often do) arise when you share your workbook with others. Remember that the linked datasource cannot be on your local system and if it is in a shared folder, they must have access to the shared folder as well.

Joseph Harris
Excel Help

If you found this article helpful, buy me a cup of coffee!

Related posts:

  1. Removing Macros from a Workbook Q: How do I remove all the macros from my...
  2. How to Import XML Data into Excel This article is a quick primer on using XML data...

This entry was posted on Thursday, February 26th, 2009 at 11:53 am and is filed under Mail Bag. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.