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.
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.
Good Info!!! Thanks Ashok
Very good information.
Thanks for your article Ashok, Can you also add the OS and the Excel version you are using in your scenario ?
Hello Anurag Tamble,
Windows 7 and MS Office 2010.
Regards
AB
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
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
Good information
Good one thankyou
Thanks for the detailed blog.
Thanks for your help on this. Expect many more like this...
Hope this exercise works for MS Office 2013.
Yes it applies to MS Office 2013. 🙂
Use full info. Thank you
hi
show error launching office client: library not registered ( exception from hresult : 0x8002801d
plz feedback
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.