SAP Knowledge Base Article - Preview

3535545 - Unable to open some EPM reports via EPM add-in or Excel

Symptom

  • Some EPM reports cannot be opened by EPM add-in.
  • You can find the error message below in EPM logs,

|ERROR|FilesManagement|FPMXLClient.Office.ExcelOfficeFile.OpenWorkbook|ZBPC|||||VSTA_Main|An error occurred while trying to open workbook "\INPUT SCHEDULES\XXXXXX.XLSM": #
|ERROR|FPMXLClient|FPMXLClient.Office.OpenSaveExcelManager.OpenLocalFile|ZBPC|||||VSTA_Main|Value cannot be null。
Parameter name: workbook#

  • You get a dialog as follows if directly opening the reports in the local machine using Excel.

Excel found unreadable content in 'FILENAME.xlsx'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes. Clicking Yes generates:

Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))


Read more...

Environment

  • SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver
  • SAP Business Planning and Consolidation 11.0, version for SAP BW/4HANA
  • SAP Business Planning and Consolidation 11.1, version for SAP BW/4HANA
  • EPM Add-in for Microsoft Office

Product

SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver ; SAP Business Planning and Consolidation 11.0, version for SAP BW/4HANA ; SAP Business Planning and Consolidation 11.1, version for SAP BW/4HANA ; SAP Business Planning and Consolidation 2021, version for SAP BW/4HANA

Keywords

EPM, BPC NW, Business Planning and Consolidation for NetWeaver, SAP BPC FOR NetWeaver,Excel, EPM add-in , KBA , EPM-BPC-NW , NetWeaver Version , EPM-XLS , EPM Excel Client , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.