Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi AO users,


We received some incidents related with installations where Analysis for Office got a message error when finishes the installation. We received also some incidents where Analysis for Office finishes the installation and do not appears at the excel tab.


Here I will describe some information about installation and troubleshooting.

== Requisites

When you are installing an Analysis for Office you have some requisites and to check those you will need to check the SAP note:


  • 1466118 Analysis Office hardware & software requirments


You also may need to check the PAM (Product Availability Matrix) for Analysis for Office so you will need to follow the below link:


You can also check the Admin Guide of Analysis for Office located on the Analysis for Office official page: http://help.sap.com/boaolap41.


== Installation

Analysis for Office is easy and friendly to install.

SAP always suggests to install the latest delivered version as it contains delivered new features.

I already described the path to find the latest support package but for those that needed I will describe below:


  1. http://service.sap.com/swdc
  2. Download
  3. Support Packages & Patches
  4. Browse Our Download Catalog
  5. Analytics Solutions
  6. SBOP ANALYSIS MS OFFICE
  7. SBOP ANALYSIS MS OFFICE 1.4
  8. Comprised Software Component Versions
  9. ANALYSIS OFFICE CLIENT 1.4

Win32 (for 32 bit Office) or Windows 64bit (for 64 bit Office)

You will execute the file and you will easily install with few next buttons.


At the first installation screen you will receive a message if you didn’t fulfill the requirements otherwise you will just click next.

At the second installation screen you will select the features to be installed.

At the end of the installation, if your installation has some issue, you will receive a message error and an inconsistent report that you can check by the installation screen clicking on Error Report.

== Installation Check

If you receive a message error you can check the installation log file by the installation check as described below:


  1. Press Start - Run
  2. Enter nwcheckworkstation
  3. Continue the appearing wizard
  4. Before clicking Finish make sure Checkbox "Collect diagnostic
  5. information for SAP Support" is checked
  6. Press Finish

On this file you have much information and to find the specific one you will check at the error folder. On the folder you will be able to see the below error:

== Settings

After the installation you have a specific setting that I would like to highlight. At the Admin guide you can see the setting “LoadBehavior” that you can define as 1,2 and 3.


  1. (value 1)The Add-In is enabled. This temporary activation means that the Add-In is disabled again when Microsoft Excel is closed.
  2. (value 2)The Add-In is disabled. Users can enable it in the COM Add-In dialog box. This sets the value to 3.
  3. (value 3)The Add-In is enabled. If required, users can disable it in the COM Add-In dialog box. This sets the value to 2.

== Common issues

We had received some incidents related with installation and the solution is simple. Sometimes we received some screenshots of “control panel/ install remove programs” with more than one version of Excel / Power Point and office packages. The same situation with the .net installation.


The Analysis for Office will work only with the Office package and not stand alone so the situation got solved removing all related installation and reinstalling from the entire Office package.


You cannot have a mixed office version installation.

If you have some suggestion about a specific topic, please describe on the comments that I will write a post about it.

Thanks,

Diego Ferrary

Support Team, NW Technology, AGS Primary Support

SAP Labs Latin America

Also check Analysis for Office’s blog: filipe.zeuch/blog

For more Analysis for Office tool please check:

16 Comments