Skip to Content
Author's profile photo Ashok Babu Kumili

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

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.

1.JPG

 

Step-2

Select Planning and Consolidation administration

2.JPG

Step-3

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

3.JPG

 

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).

4.JPG

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

4_1.JPG

Image-4.2

4_2.JPG

Image-4.3

4_3.JPG

Image-4.4

4_4.JPG

Image-4.5

4_5.JPG

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.

Final_1.JPG

Assigned tags

      15 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Naresh C
      Naresh C

      Good Info!!! Thanks Ashok

      Author's profile photo Former Member
      Former Member

      Very good information.

      Author's profile photo Former Member
      Former Member

      Thanks for your article Ashok, Can you also add the OS and the Excel version you are using in your scenario ?

      Author's profile photo Ashok Babu Kumili
      Ashok Babu Kumili
      Blog Post Author

      Hello Anurag Tamble,

      Windows 7 and MS Office 2010.

      Regards

      AB

      Author's profile photo Former Member
      Former Member

      Good article Ashok. Can you please share a similar document for Windows 7 and Office 2013.You cannot change the control panel settings when it comes to Office 2013. I am stuck with an error "The Following pre requisites are required - Microsoft Visual Basic for Application 2013 or later".

      Regards,

      Sowmya

      Author's profile photo Ashok Babu Kumili
      Ashok Babu Kumili
      Blog Post Author

      Hi Sowmya,

      My colleagues faced the similar issue in Window-7 and MS office 2013. The steps followed is same and they could fix this.

      Well a clue.

      1) If you have the admin prevelages in your computer

      2) Go to run command and type appwiz.cpl

      3) Find the MS office 2013

      4) Follow from the step-1 in the blob.

      Hope this is helpful.. Thank you

      Author's profile photo Former Member
      Former Member

      Good information

      Author's profile photo Former Member
      Former Member

      Good one thankyou

      Author's profile photo Former Member
      Former Member

      Thanks for the detailed blog.

      Author's profile photo Former Member
      Former Member

      Thanks for your help on this. Expect many more like this...

      Author's profile photo Former Member
      Former Member

      Hope this exercise works for MS Office 2013.

      Author's profile photo Ashok Babu Kumili
      Ashok Babu Kumili
      Blog Post Author

      Yes it applies to MS Office 2013. 🙂

      Author's profile photo Former Member
      Former Member

      Use full info. Thank you

      Author's profile photo Former Member
      Former Member

      hi

      show error launching office client: library not registered ( exception from hresult : 0x8002801d

      plz feedback

      Author's profile photo Former Member
      Former Member

      To configure and connect to SAP BPC system,  absolutely you need to login through EPM  Add-in (MS Excel) .Even i tried it it worked well.