AFX Error : Could not start(or attach to) Excel application

[shreyasramdhave]

Hi All,

For one of our user we are getting below error when trying to open AFX workbook from BO server.

**** Trace file opened by process 10096 at 2018-07-03 14:50:30 (UTC+05:30 India Standard Time)

SAP .NET Connector 3.0 with file version 3.1.0.3 running on 32-bit .NET Framework 4.0.30319.42000

Program: C:\Program Files (x86)\Microsoft Office\Root\Office16\EXCEL.EXE

Working directory: C:\Users\*****\Documents

Operating system: Windows 10 Enterprise 64-bit

Processor: 4x AMD64 (or x64)

SAP release: 749, Kernel release: 749, Kernel patch level: 414

Hostname: ******, IP address: 10.75.236.70, IP_v6 address:

Default trace level: RemoteFunctionCall,PublicAPI,InternalAPI,RfcData

2018-07-03 14:50:30.122 RfcConnection.Close() <connection [convID= null]>

2018-07-03 14:50:30.122 RfcConnection.Close() OK

One more error from logfile

FILE_TYPE:DAAA96DE-B0FB-4c6e-AF7B-A445F5BF9BE2

RECORD_SEPARATOR:35

COLUMN_SEPARATOR:124

COLUMNS:Time|Severity|Category|Method|Thread|Text

SEVERITY_MAP:DEBUG|Debug|INFO|Information|VERBOSE|Verbose|WARNING|Warning|ERROR|Error|FATAL|Fatal

HEADER_END

2018-07-02 14:25:53,122|ERROR|Trace.Cof|Com.Sap.Cof.Core.Excel.ExcelEventsDispatcher.RegisterEmbeddedWorkbook|VSTA_Main|RegisterEmbeddedWorkbook failed! Workbook already registered: #

Regards

Shreyas

[former_member186338]

This question is not related to the tag:

EPM Add-In for Excel

Please select a correct one!

[sayalib25]

We were able to resolve this issue -

AFO (or AFX) is related to your MS Office version. If you have installed EPM Add-in and you can open Analysis for Office on your desktop and still getting this error, then your MS Office version is not compatible.

This is what we found till now -

MS Office Version 2303 - NOT Compatible with AFO

MS Office Version 2302 - Compatible with AFO

Also, open your excel and go to File -> Options -> Add-ins and make sure Analysis and Analysis ToolPak are active.

If they are not, click on Go next to Manage Excel Add-ins, tick all the options and say OK. Follow the same for COM add-in and it will open 'Analysis' tab next to Help in your excel.

Regards,

Sayali