Configure EPM Add-In (MS Office Excel) and troubleshooting configuration issues.

[former_member181999]

Background:

When I was on boarded to my new SAP BPC 10.0 project. I was given the BPC Server login and asked to configure and connect to SAP BPC system. So I tried connecting to BPC system thru EPM  Add-in (MS Excel) Login.

My desktop do not have pre-installed EPM Add-in so with the help of our basis team I followed certain steps. Due to the dependency on other team for configuring BPC EMP Add-In MS-Excel and the below issue I lost few project hours. I though this will be help to others and sharing to the community.

Step-1

Please log-on to the BPC server.



 

Step-2

Select Planning and Consolidation administration

Step-3

Down the EPM Add-In setup file to your local Disk



 

Step-4

After executing the EPMadd-in setup file I faced the below error.


Note: I encountered the following issue -Required "Microsoft Visual Basic for Application 2010" when I tried to installing the setup file (shared in Step-3).



Issue Root Cause: During the MS office installation my system administrator decided to do a lean/light installation (For Less disk space occupation and quicker installation time)

Solution for the issue:

1) Go to My Computer and thee Control Panel. And select as shown below.

2) Choose Uninstall or change a program.

3) Goto -Microsoft Office Professional. Select Change

Image-4.1




Image-4.2



Image-4.3



Image-4.4



Image-4.5



Step-5

Now after doing the configuration shown in the step-4. I could see the EPM Office Add in Excel added to the Excel and portal shows me the updated links as below.