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.
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.
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.
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.
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.
Bookmarks