Broadcasting Workbook Error

[Former Member]

Hi,

I am getting following error when trying to broadcast the work.

Status of the Precalculation server is green.

Please help to solve the same .

___________________________________________________

The system contacts preliminary calculation server PRETEST

A preliminary calculation server has been found

Precalculation server was started

Load workbook OARFYZFJBSUNH4SKT0QAORX3S

Precalculation server queue updated: Server PRETEST setting A9FE01E816844EB3860A06FC00000000

Start precalculation on precalculation server 'PREC_PRETEST' for setting 'TEST_2'

Unresolved exception occurred on the precalculation server

System.Runtime.InteropServices.COMException (0x800 0A03EC): Microsoft Office Excel cannot access the

ile 'C:\Program Files (x86)\Common Files\SAP Share ed\BW\BExAnalyzer.xla'. There are several possible

reasons:

• The file name or path does not exist.

• The file is being used by another program.

• The workbook you are trying to save has the same

name as a currently open workbook.

at Microsoft.VisualBasic.CompilerServices.LateB Binding.LateGet(Object o, Type objType, String nam

, Object[] args, String[] paramnames, Boolean[] Co

pyBack)

at Microsoft.VisualBasic.CompilerServices.NewLa ateBinding.LateGet(Object Instance, Type Type, Str

ng MemberName, Object[] Arguments, String[] Argume

ntNames, Type[] TypeArguments, Boolean[] CopyBack)

at com.sap.bi.et.precalculation.BexExcelPrecDll l.InitConnection(String iSysno, String iUser, Stri

g iGWService, String IGWHost, String iSessionid, S String iNewVersion, String& eMessage, Boolean iWit

Connection)

at com.sap.bi.et.precalculation.BExPreCalcRFCSe erverImpl.RS_PREC_LAUNCH_EXCEL(String GWHOST, Stri

g GWSERVICE, String JOBNAME, String NEWVERSION, St tring SESSIONID, String SYSNO, String USER, BICS_P

OV_T_MESSAGE& E_T_MESSAGE)

Microsoft Office Excel cannot access the file 'C:\ \Program Files (x86)\Common Files\SAP Shared\BW\BE

Analyzer.xla'. There are several possible reasons:

• The file name or path does not exist.

• The file is being used by another program.

• The workbook you are trying to save has the same

name as a currently open workbook.

at Microsoft.VisualBasic.CompilerServices.LateB Binding.LateGet(Object o, Type objType, String nam

, Object[] args, String[] paramnames, Boolean[] Co

pyBack)

at Microsoft.VisualBasic.CompilerServices.NewLa ateBinding.LateGet(Object Instance, Type Type, Str

ng MemberName, Object[] Arguments, String[] Argume

ntNames, Type[] TypeArguments, Boolean[] CopyBack)

at com.sap.bi.et.precalculation.BexExcelPrecDll l.InitConnection(String iSysno, String iUser, Stri

g iGWService, String IGWHost, String iSessionid, S String iNewVersion, String& eMessage, Boolean iWit

Connection)

at com.sap.bi.et.precalculation.BExPreCalcRFCSe erverImpl.RS_PREC_LAUNCH_EXCEL(String GWHOST, Stri

g GWSERVICE, String JOBNAME, String NEWVERSION, St tring SESSIONID, String SYSNO, String USER, BICS_P

OV_T_MESSAGE& E_T_MESSAGE)

Connection not passed

Packages processed on server 4-. Remaining packages:

Precalculation server queue updated: Server PRETEST setting A9FE01E816844EB3860A06FC00000000

Cannot precalculate workbook Secondary Sales NSV Day Wise

Thanks in Advance,

Vaibhav

[Former Member]

Hello member's,

I have the same Error Message. Is there any solution at the time ?

@vaibhav advirkar: Do you have a solution for this problem?

Regards

Herko

[Former Member]

Hi,

Finally I got the solution for the above problemu2014

1.Create directory "C:\Windows\SysWOW64\config\systemprofile\Desktop " (for 64 bit Windows) or "C:\Windows\System32\config\systemprofile\Desktop " (for 32 bit Windows)

2.Set Full control permissions for directory Desktop

Thanks,

Vaibhav

[saptech_user_01]

Hi Vaibhav....

Thanks a lot for this solution....!!! I had exactly the same issue and this is 100% spot on !!

Works like a charm !!