- Creating simple cell formulas
- Assigning names to groups of cells
- Using names in formulas
- Creating a formula that references values in an Excel table
- Creating formulas that reference cells in other workbooks
- Changing links to different workbooks
- Analyzing data by using the Quick Analysis lens
- Summing a group of cells without using a formula
- Creating a summary formula
- Summing with subtotals and grand totals
- Exploring the Excel function library
- Using the IF function
- Checking formula references
- Debugging your formulas
Changing links to different workbooks
If you create a link to a value in another workbook, you might find that the other workbook’s structure changes. You can update the properties of a link by using the Edit Links dialog box, which you can open using the controls on the Data tab of the ribbon.
Change links to different workbooks
Click the Data tab.
In the Connections group, click Edit Links.
Click the link that you want to change.
Click Change Source.
Click the workbook with the new cell to which you want to link.
Select the sheet from which to update values.