CPM Analysis menu
The menu includes the same commands as the toolbar plus additional commands not available from the toolbar.
-
temporarily replaces the displayed
values of all inserted data in a workbook with empty cells until a user signs
in and refreshes the workbook data. This command is used for security purposes
prior to sharing workbooks with restricted users.
- To restore the cleared data, click from the toolbar or menu. For more information, see "To Restore Cleared Data."
- unlocks all cells and clears all constraints within the entire workbook (not just the current worksheet) that were previously locked for top down spreading. This command affects all cells in all the worksheets, including off-grid data slices (for any dataset). For more information, see "Locking/Unlocking Cells" and "Setting/Removing Constraints."
- maps the components of an Excel formula. The lowest level components (that cause the value to change) are highlighted on the worksheet. For more information, see "Analyzing Formulas."
- or replaces Excel's protection feature, to enable CBR users to protect a worksheet from changes in the worksheet. For more information, see "Protecting/Unprotecting Worksheets."
- builds a writable, collapsible map that shows all the components that impact a formula's calculated result all the way to the leaf level. For more information, see "Generating a Formula Map."
- reverses the effects of the last top down spread. This command is enabled only after a top down spread is performed. For more information, see "Top Down Spreading."
- shows the URL for the server computer. This command enables you to see which server computer the worksheet is connected to.