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
SAP Knowledge Base Article - Public