Set the WKBK_AUTO_CALCULATE_ONLOAD application preference
- Access the CCPREF—Preference application from the main menu or quick launch to display the CCPREF—Search Preference screen.
- Enter the Preference Name—WKBK_AUTO_CALCULATE_ONLOAD
- Click Submit.
- Open the preference with the lowest level of scope to display the CCPREF—Preference Detail screen.
- If Is System is selected, then clear it and click Submit.
- Ensure that Setting Type is set to BOOLEAN.
- To turn on the recalculation of all workbook cells that have a formula when a workbook is opened, select Setting Value.
- To turn off the recalculation of all workbook cells that have a formula when a workbook is opened, clear Setting Value.
- Set the Preference Type to PREFERENCE.
- Ensure Is Active is selected.
- Click Submit.
- If Is System was initially selected, then ensure it is reselected and click Submit.
