Most common issues with Analysis for Office 2.8 SP6
Dear SAP Community,
we have rolled out Analysis for Office 2.8 SP6 to a wider group of users. While doing that we gained some experience on the behavior and issues that occured while rolling out this new version. I have collected all issues and the resolution steps in order to help you in case you are facing similar issues. One important remark: I can not judge whether there are any dependencies on other Excel Add-ins or applications that you are using.
Do I need to uninstall my current Analysis for Office?
It is not required to uninstall your current version of AfO but we have observed that some users where facing issues after directly upgrading with uninstalling the current AfO instance. My suggestion would be to install the latest version first and see if everything is working as excpected.
Do I have to do anything after the Update?
Please clear your AfO Cache after the updating by going the following path: Open AfO → File → Customize Analysis → Options → Platform → Clear Cache. Note: there won’t be any message coming up after pressing the button. Clearing the cache can resolve the following issues: numbers are displayed incorrectly, functions are not getting executed or the the formatting is disrupted. You may also deactivate the workbook caching.
Specific error messages:
I am getting a message saying “Unsecure connection”. What do I have to do?
Don’t worry, in case your connections have been secure before and if the connections did not change, then this will not be a security problem. If you do not want to receive this message any more you can turn it off by doing the following: open Analysis for Office → File → Analysis → Customize Analysis → Technical Configuration → change the setting AllowInsecureConnections to „yes“.
I am getting a message saying “Couldn’t establish a secure connection”. What do I have to do?
This message comes up when you try to open a file from a local drive which has been saved with an older version of Analysis for Office and the name of the system connection has changed. In order to resolve this you have to open the local file and manually establish a connection by going to Insert Data Source Define → Select source for Analysis → And then connect to your preferred system. After that you can open and refresh the workbook and then you have to update the settings by going to Analysis for Office → File → Analysis → Customize Analysis → Technical Configuration → Tick the box for ForceRefreshConnection and save the workbook. After that you should be able to open the local file without any problems.
Edit: This message will occur for different reasons. You can turn this off by starting AfO as an Administrator (Right click on the application icon and select “Run as Administrator” from the context menu). Go to Analysis for Office → File → Analysis → Customize Analysis → Technical Configuration → Untick the box for EnableWarningForFailedSnc. After restarting AfO the message should not show up anymore.
I am getting a message saying “An error occurred while trying to apply the default User Interface Customization profile”. What do I have to do?
1. uninstall AfO 2.8
2. remove manually the outdated EPMAddin folder under C:\Program Files (x86)\SAP BusinessObjects\Office AddIn\Plugins\EPMAddin
3. reinstall AfO 2.8
I am getting a message saying: “Error details: Could not load file or assembly ‘FPMXLClient.Common, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null’ or one of its dependencies. The system cannof find the file specified.”
If you haven’t upgraded yet to AfO 2.8, please uninstall all previous versions of Analysis for Office. By doing this you can avoid above error message. In addition you should also manually remove the outdated EPM Addin folder under C:\Program Files (x86)\SAP BusinessObjects\Office AddIn\Plugins\EPMAddin. Keep in mind that this might remove your Favorites from the SAP Logon Pad and you might want to save them before.
If you are already getting this error message, please uninstall all previous version of Analysis for Office and check if the issue got resolved. If the error message remains, please also re-install AfO 2.8 SP6. After that the issue should be resolved.
After the upgrade AfO is glitching. Eg when using the scrollbar the dropdown menus are randomly opening. What can I do?
This is issue is mainly occuring when using a secondary monitor. When AfO is opened on the primary monitor there should not be any issue. Please check the following settings.
I am getting a message saying: “The given assembly name or codebase was invalid. (Exception from HRESULT: 0x80131047)“
As per SAP Note 2876424 we can try the following:
- Uninstall Analysis for Office
- Afterwards check if the folder “C:\Program Files (x86)\SAP BusinessObjects\Office AddIn” is empty
- Then remove the node “HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\SapExcelAddIn” via registry settings (i.e. regedit)
- Reinstall AO and check if the issue is solved.
I am getting a message saying: “Downloading file:///C:/Program Files (x86)/SAP BusinessObjects/Office AddIn/SapExcelAddIn.vsto did not succeed”
Please check if the SapExcelAddin.vsto file is available under C:/Program Files (x86)/SAP BusinessObjects/Office AddIn/. If the folder is empty, it might be an indicator that the installation did not work properly. In this case we would advise you to check this with your local IT Team as there might be an issue with your machine or there might be some dependency with older installations of AfO.
As you can see in the above list, there were a couple of issues that we were facing when distributing the latest AfO Version to our user community. We were either able to resolve these issues on our own or by reaching out the SAP Support. So i hope that this list will help you in case you are facing similar issues from your end. Please feel free to add any further issues that you are facing or any other tips that would be helpful for the SAP Community.