SAP Knowledge Base Article - Public

3699774 - Schedule AO workbook is corrupted and cannot be opened by Excel

Symptom

When the scheduled workbook is opened, Excel displays a dialog box saying "We found a problem with some content in '<workbook_name>'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes."

Environment

SAP Analysis for Microsoft Office

Reproducing the Issue

Try to open the Excel file resulting from a scheduled AO workbook.

Cause

An Analysis Office BIP Add On program error where invalid number formats may be generated if the currency / unit in the number format is empty.

Resolution

The code correction is delivered with Analysis Office BIP Add On 2.8 SP 27 as per SAP Note 3623798 - Corrupted Workbook due to incorrect number formats.
The Analsyis Office BIP Add On version installed in your Bi Platform must be upgraded to a version that contains the code correction.

See Also

SAP Note - 3623798 - Corrupted Workbook due to incorrect number formats

Keywords

number formats, corrupted workbook , KBA , BI-RA-AO-BIP , AO Precalculation, Scheduling and AO InfoOb... , Problem

Product

SAP Analysis for Microsoft Office all versions