Can i link two excel workbooks

Press Enter. You are returned to the destination cell, which now displays the data from the source cell. In the destination cell, follow the instructions for your version of Excel: Excel and up: Go to the Home tab. Under Paste choose Paste Link. From the source worksheet, use the ESC button to get rid of the animated border. You can also link a range of cells by following these steps: Select the cell range you wish to duplicate.

Click Copy. On the destination sheet, click the cell where you want the range of data to begin, select Paste Link. Each cell will have a unique link formula that references the source worksheet. When the worksheets share the same workbook, you can manually enter the formula. Data Analysis Fundamentals with Excel Video. Sign in. Your cart. Back Page 2 of 5 Next. A 3-D cell reference to another workbook.

TIP For references to cells in the same workbook, the workbook information is omitted. Click to view larger image Link to an Excel table value in another workbook. Click to view larger image Cells that contain incorrect links display a REF!

Manage workbook links by using the Edit Links dialog box. Like us on Facebook Follow us on Twitter Save to your account. See Naming and Renaming Worksheets. In linking formulas, spaces or special characters must be wrapped in single quotes ; e. Excel automatically wraps worksheet names C or R in single quotes.

To link a range of cells, select the cells and click Copy. Cell values in the range will be linked, and will display on the destination sheet. Each cell in the range will contain its own link formula which references the corresponding cell in the source worksheet. If the worksheets are in different workbooks in the same folder or directory , the formula must also include the workbook name in brackets as shown. If the workbooks are in different folders, the formula would have to include the complete file path as well, so it is best to avoid this situation.

Don't forget that versions older than Excel have a file extension of xls. If the source and destination worksheets are in the same workbook, moving the workbook to a different folder or even a different computer should not be a problem. But if either worksheet is moved to a different folder, the link will break!

Also, companies that store worksheets on network servers have additional factors to consider that are outside the scope of this tutorial. To ensure that the external cell reference automatically updates when the source is updated, follow the steps below for your version of Excel:.

Method One : On the Calculation section of the Excel ribbon, click the small arrow by Calculation Options and select Automatic as shown. On the left, click Formulas , and ensure Automatically is checked under "Calculation Options.