Set the WKBK_AUTO_CALCULATE_ONLOAD application preference

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