Unless you delete a worksheet or workbook, or move a workbook to a new folder, odds are good that Excel can update your link references automatically to reflect the change. When you press Enter and switch back to the workbook with the target cell, the value in the formula bar shows that Excel has filled in the formula with a reference to the cell you clicked.Įxcel tracks workbook changes, such as when you change a workbook’s name, very well. You can link to a cell in another workbook by starting to create your formula, displaying the worksheet that contains the value you want to use, and then selecting the cell or cell range you want to include in the calculation. Instead of entering a value into the target cell by typing or pasting, you create a formula that identifies the source from which Excel derives the target cell’s value, and that updates the value when it changes in the source cell. You can ensure that the data in the target cell reflects any changes in the original cell by creating a link between the two cells. In other words, copying and pasting a cell’s contents doesn’t create a relationship between the original cell and the target cell.
Link to data in other worksheets and workbooksĬopying and pasting data from one workbook to another is a quick and easy way to gather related data in one place, but there is a substantial limitation: If the data from the original cell changes, the change is not reflected in the cell to which the data was copied.
0 kommentar(er)
