SAP Knowledge Base Article - Preview

2853694 - Error "Unable to get the Open property of the Workbooks class" in BW Precalculation

Symptom

SAP BW Precalculation failed.

Precalculation Server log "BExPrecalcLog.txt" ends with entry like following:

-> Trying to open "C:\Program Files (x86)\Common Files\SAP Shared\BW\BExAnalyzer.xla"
-> Enter semaphore for BExAnalyzer addin
-> BExExcelPrecDll.ExcelApp: CreateObject for Excel.Application called.  

Broadcasting Log in transaction RSRD_LOG shows:

Untreated exception on the precalculation server
System.Runtime.InteropServices.COMException (0x800 0A03EC): Unable to get the Open property of the Wo
kbooks class
   at Microsoft.VisualBasic.CompilerServices.LateB Binding.LateGet(Object o, Type objType,
, Object[] args, String[] paramnames, Boolean[] Co
pyBack)
   at Microsoft.VisualBasic.CompilerServices.NewLa ateBinding.LateGet(Object Instance, Typ
ng MemberName, Object[] Arguments, String[] Argument

The precalculation works in Console Mode.


Read more...

Environment

  • SAP Netweaver BW Release Independent
  • SAP BW Precalculation Release Independent

Product

SAP NetWeaver all versions

Keywords

Precalculation, Unable to get the Open property of the Workbooks class , KBA , BW-BEX-ET-BC-PREC , Precalculation Server / Export of Workbooks , How To

About this page

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

Search for additional results

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