SAP Knowledge Base Article - Public

2408882 - "Refresh Workbook on Opening" flag is unchecked in scheduled workbook

Symptom

The Analysis workbook has the option "Refresh Workbook on Opening" selected and it is scheduled in BI platform. When opening the scheduled workbook, the option "Refresh Workbook on Opening" is unchecked/not selected.

Environment

SAP BusinessObjects Analysis, edition for Microsoft Office

Reproducing the Issue

  1. Schedule an Analysis workbook in BI platform;
  2. Open the scheduled workbook in Analysis for Office;
  3. Confirm that the option "Refresh Workbook on Opening" is unchecked.

Resolution

This is the standard behavior. Even if the workbook has the option "Refresh Workbook on Opening" selected, this flag is unchecked in the scheduled workbook so its data does not change after opening it.

Keywords

precalculate, scheduling, scheduled, flag, refreshing, precalculating, opening, open, settings, not selected, blank, untick , KBA , BI-RA-AO-BIP , AO Precalculation, Scheduling and AO InfoOb... , BI-RA-AO-XLA , Excel Addin , How To

Product

SAP Analysis for Microsoft Office all versions