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.