Show TOC

Precalculation RestrictionsLocate this document in the navigation structure

There are precalculation restrictions for the following workbook settings and elements:
  • The setting Refresh Workbook on Opening is ignored.
  • The setting Force Prompt for Initial Refresh is ignored.
  • If the setting Remove Data Before Saving is selected, the workbook is not precalculated.
  • If the workbook is in protected mode, it is not precalculated.
  • SAP formulas concatenating other SAP formulas are not precalculated.
  • Excel formulas are not precalculated.
  • VBA macros are not executed during precalculation.
  • Icons are ignored, for example arrows in conditional formats.
  • Comments are ignored.