Configure EPM Add-In (MS Office Excel) and troubleshooting configuration issues.
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.
Please log-on to the BPC server.
Select Planning and Consolidation administration
Down the EPM Add-In setup file to your local Disk
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
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.