Microsoft Office Tutorials and References
In Depth Information
To Create a Workspace File
2
Click the Save Workspace button
on the Ribbon.
Save Workspace
dialog box
UDISK 2.0 (E:)
selected
When Excel displays the Save
Workspace dialog box, select
UDISK 2.0 (E:) in the Address
bar and then type NextDVR
Workspace in the File name box
(Figure 6–88).
Can I still open the workbooks
separately or must I always open
the workspace?
After the workspace is saved to
disk, you can open the workbooks
one at a time as you did in the
past, or you can open all of the
associated workbooks by opening
the workspace. When you invoke
the Open command, workspace
fi le names appear in the Open
dialog box, the same as any
workbook fi le name.
workspace
fi le name
Save button
fi le type is
Workspaces
3
Click the Save button in the Save
Workspace dialog box to save the
fi le names of the workbooks open, of
the workbooks displaying, and other display settings.
Figure 6–88
If the Microsoft Offi ce Excel dialog box is displayed for any of the workbooks, click the No button.
Click the Offi ce Button and then click the Exit Excel button on the Offi ce Button menu to quit Excel.
If the Microsoft Offi ce Excel dialog box is displayed for any of the workbooks, click the No button.
Other Ways
1. Press ALT + W , K
To Consolidate Data by Linking Workbooks
The following steps show how to open the workspace fi le NextDVR Workspace and
consolidate the data from the three region workbooks into the NDVR Company Profi t
Potential workbook.
1 Start Excel as described on page EX 423. Click the Offi ce Button and then click Open on
the Offi ce Button menu. When Excel displays the Open dialog box, select UDISK 2.0 (E:)
in the Address bar. Double-click NextDVR Workspace to open the four workbooks saved in
the workspace. Make NDVR Company Profi t Potential the active worksheet. If necessary,
double-click the NDVR Company Profi t Potential window title bar to maximize it.
2 Select cell B5. Click the Sum button on the Home tab on the Ribbon. Click the View tab on
the Ribbon and then click the Switch Windows button arrow on the Ribbon. Click NDVR
Louisville Profi t Potential on the Switch Windows menu. Click 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.
 
 
Search JabSto ::




Custom Search