Microsoft Office Tutorials and References
In Depth Information
Linking to data in other
TIP Yes, cell C15 on the Plane Repair worksheet contains the wrong total for the
Airplane Fuel category; that’s why you replace it later in this exercise.
In the Switch Windows list, click FleetOperatingCosts to display the
Right-click the Plane Repair sheet tab, and then click Delete . In the message box that
appears, click Delete to confirm that you want to delete the worksheet.
In the Switch Windows list, click OperatingExpenseDashboard to display the
OperatingExpenseDashboard workbook. Note that cell I6 shows a #REF! error
because the worksheet containing the linked cell has been deleted.
On the Data tab, in the Connections group, click Edit Links to open the Edit Links