Results 1 to 4 of 4

Thread: How to link multiple workbooks?

  1. #1
    Join Date
    Aug 2009
    Posts
    31

    How to link multiple workbooks?

    I have created 3 workbook in Microsoft excel. Workbook 1 with employee data and workbook 2 with user id and workbook 3 with employee address. Can any one tell me how to link workbooks in excel to change data in all three workbook simultaneously.

  2. #2
    Join Date
    May 2008
    Posts
    4,831

    Re: How to link multiple workbooks?

    Follow this step to link workbooks in excel :

    • Open both workbooks.
    • In the source workbook, select the cells you want to link to and click the Copy button.
    • Switch to the destination workbook and click the upper left cell of the range where you want the links.
    • On the Edit menu, click Paste Special, and then click Paste Link.

  3. #3
    Join Date
    Dec 2008
    Posts
    371

    Re: How to link multiple workbooks?

    You can create link to another workbook in excel. To give link select data (employee workbook 1) you want to copy in one workbook and select Edit, Copy. When you select copy from one workbook paste it to another workbook go to Edit in to another workbook Paste Special, and press the Paste Link button. When you open a workbook that contains external links in Microsoft Office Excel 2007 or in a later version of Microsoft Excel, you are prompted to update the links.

  4. #4
    Join Date
    May 2008
    Posts
    4,345

    Re: How to link multiple workbooks?

    Copy a range of cells Workbook1 with employee data or employee id from another data and select a cell in another sheet or workbook. Select Home -> Paste arrow (in Clipboard Group) -> Paste Link Or Press Shift+F10 or right-click, and then select Paste Special from the shortcut menu, and clicshortcut menu, and click Paste Link.k Paste Link.

Similar Threads

  1. Replies: 6
    Last Post: 24-02-2012, 01:50 PM
  2. Snap feature from windows 7 with excel workbooks
    By laplapye in forum Windows Software
    Replies: 4
    Last Post: 28-11-2010, 01:49 AM
  3. Merging workbooks in excel 2007
    By rico123 in forum Tips & Tweaks
    Replies: 1
    Last Post: 26-07-2010, 10:24 AM
  4. How to minimize Metadata in Microsoft Excel Workbooks?
    By Orton in forum Windows Software
    Replies: 5
    Last Post: 10-03-2010, 05:57 AM
  5. Replies: 5
    Last Post: 22-01-2010, 04:39 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,721,233.44999 seconds with 16 queries