Force the recalculation of formulas

1. Open a workbook session in normal mode to display the CCWKOP—Workbook Open Detail screen or in transposed mode to display the CCWKOP—Workbook Open Transposed Detail screen.
2. Select cells that contain formulas.
3. Access the Recalculate Formulas native workbook command (accessed via a workbook menu).

   The formulas in the selected cells are recalculated and their results undergo the system processes following result entry and the cells are redisplayed with updated cell locks and highlighting.

4. Click Submit to save the changes made during the workbook session.

Note: The BLOCK_FORMULA_UPDATE preference, if active and set to have RELEASED and/or COMPLETED as preference values, will protect the workbook cell from recalculating if the workflow status of the cell is either RELEASED or COMPLETED.