32 Excel
Linked Formulas
Many of the StatPlus commands use custom formulas to calculate statistical
and mathematical values. One advantage of these formulas is that if the
source data in your statistical analysis is changed, the formulas will refl ect
the changed data. A disadvantage is that if your workbook is moved to an-
other computer in which StatPlus is not installed (or installed in a different
folder), those formulas will no longer work.
If you decide to move your workbook to a new location, you can freeze
the data in your workbook, removing the custom formulas but keeping the
values. Once a formula has been frozen, the value will not be updated if the
source data changes. A frozen workbook can be opened on other computers
running Excel without error.
If the other computer also has the StatPlus add-in installed but in a differ-
ent folder, you can still use the custom formulas by pointing the workbook
to the new location of the StatPlus add-in fi le. Table 1-6 describes the vari-
ous linked formula commands (available in the StatPlus General Utilities
submenu).Table 1-6 Linked Formula Commands
Command Description
Resolve StatPlus links Find the location of the StatPlus add-in on the current
computer and attach custom formulas to the new location
Freeze data in worksheet Freeze all data on the current worksheet
Freeze hidden data Freeze all data on hidden worksheets
Freeze data in workbook Freeze all data in the current workbookSetup Options
If you want to control how StatPlus operates in Excel, you can open the
StatPlus Options dialog box from the StatPlus menu. The dialog box, shown
in Figure 1-24 is divided into the four dialog sheets: Input, Output, Charts,
Hidden Data.