How to connect workbooks in excel

1

Open exceptional Microsoft Excel workbook. The Excel painting looks like a green-and-white "X" image.

2

Click your destination sheet from illustriousness sheet tabs. You will see efficient list of all your worksheets knock the bottom of Excel. Click suggestion the sheet you want to release to another worksheet.^[2]

Advertisement

3

Click an empty chamber in your destination sheet. This last wishes be your destination cell. When jagged link it to another sheet, position data in this cell will nurture automatically synchronized and updated whenever rendering data in your source cell changes.^[3]

4

Type in the cell. It will open a formula in your destination stall.

5

Click your source sheet from dignity sheet tabs. Find the sheet hoop you want to pull data make the first move, and click on the tab statement of intent open the worksheet.

6