Microsoft Office Tutorials and References
In Depth Information
Updating Links
Workspace Files
A workspace fi le saves
display information
about open workbooks,
such as window sizes,
print areas, screen mag-
nifi cation, and display
settings. Workspace fi les
do not contain the
workbooks themselves.
3 Click the Switch Windows button arrow on the Ribbon and then click NDVR Kansas City
Profi t Potential. Select cell B5. Delete the dollar signs ($) in the reference to cell B5 in the
formula bar. Click immediately after B5 in the formula bar and then press the COMMA key.
4 Click the Switch Windows button arrow on the Ribbon and then click NDVR Portland
Profi t Potential. Select cell B5. Delete the dollar signs ($) in the reference to cell B5 in the
formula bar. Click the Enter box.
5 With cell B5 active in the NDVR Company Profi t Potential workbook, drag the cell’s fi ll
handle through cell B11. Select cell B5 (Figure 6–89).
6 Click the Save button on the Quick Access Toolbar. If Excel displays a dialog box, select
Overwrite changes. Click the OK button. Click the Offi ce Button, click Print on the Offi ce
Button menu, and then click the OK button in the Print dialog box to print the workbook.
Why did the formulas need to be edited for each workbook?
As you link workbooks, remember that the cell reference inserted by Excel each time you
click a cell in a workbook is an absolute cell reference ($B$5). You must edit the formula
and change these to relative cell references because the SUM function later is copied to the
range B6:B11. If the cell references are left as absolute, then the copied function always
would refer to cell B5 in the three workbooks no matter where you copy the SUM function.
NDVR Company
Profi t Potential shows
consolidation of three
store workbooks
SUM function
with fi le names,
sheet name, and
cell references
location E:\ not
required in cell
reference because
linked workbooks
are in same folder as
active workbook
sum of values in
cell B5 in three
workbooks
Excel Help
The best way to become
familiar with Excel Help
is to use it. Appendix C
includes detailed infor-
mation about Excel Help
and exercises that will
help you gain confi dence
in using it.
SUM function in
cell B5 copied to
cells B6:B11
Figure 6–89
Updating Links
Later, if you open the NDVR Company Profi t Potential workbook by itself, also
called the dependent workbook , Excel will update the links automatically if the linked
workbooks are open. The linked workbooks are called the source workbooks . If the linked
workbooks are not open, then Excel displays a security warning in a pane below the Ribbon.
If you click the Options button in the security warning pane, Excel displays the Microsoft
 
 
Search JabSto ::




Custom Search