SAP Analysis Addin for Excel error

[jerryjanda]

Whenever I open an SAP Analysis excel file, I get (sometimes with a little delay) this error message:

"Could not start (or attach to) Excel Application"

( |ERROR|addins.launcher|Com.Sap.Cof.Launcher.Launcher.Main|1|Could not start (or attach to) Excel Application )

If I open my file directly via Excel, despite the error popup the file displays and I can work on it.

However, if I save a .sapaox Launchfile for it from a web portal and then open it that way, I still get the error as usual but the file appears to be empty

|ERROR|addins.launcher|Com.Sap.Cof.Launcher.Launcher.Main|1|System.Exception: Could not start (or attach to) Excel Application
   at Com.Sap.Cof.Launcher.LauncherApplication.StartNewOfficeApplication(OfficeGetterHelper iOfficeGetterHelper, Boolean& oOfficeIsReused)
   at Com.Sap.Cof.Launcher.LauncherApplication.StartApplication(OfficeGetterHelper iOfficeGetterHelper, IOfficeApplication& oOfficeApplication, ICOMAddIn& oComAddIn, Boolean& oOfficeIsReused)
   at Com.Sap.Cof.Launcher.LauncherApplication.StartApplicationAndCallCOM(OfficeGetterHelper iOfficeGetterHelper)
   at Com.Sap.Cof.Launcher.Launcher.Main(String[] args)
#

[jerryjanda]

Welcome to the SAP Community! Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Secondly, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html as well, as that will help you when submitting questions to the community.

Finally, I recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

Kind regards,

--Jerry

[former_member623236]

We have the same issue since we patched our office.

Reinstall of Analysis and Office does not help.

Excel-Version: 16.0.15225.20172

Analysis: 2.8.1400.8665

[former_member1330240]

A device reset+windows update for another user fixed the .sapaox files opening as empty, but no clue about the error popups still

[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 (32 - bit)

MS Office Version 2302 (16.0.16130.20374) - Compatible with AFO (32 - bit)

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

[former_member186338]

Try to uninstall and reinstall Analysis. Then maybe Office.