Skip to Content
Author's profile photo Former Member

Installing EPM add-in on Microsoft Office 2013: Fix for Visual Basic For Application 2013 Or Later Needed Error.

Many colleagues have experienced difficulty attempting to install the EPM add-in on Microsoft Office 2013 due to the following error message: “THE FOLLOWING COMPONENTS ARE REQUIRED: – MICROSOFT VISUAL BASIC FOR APPLICATION 2013 OR LATER”. Thus we need to locate an installer for Visual Basic for Application 2013 or later. (Important: I spent a long time attempting to locate a VBA 2015 Module that came from a “trusted and unbiased” website such as The only website that I was able to locate that will provide all users this piece of VBA software comes from the Autocad Support website. I am not advertising for Autocad, but simply providing a link to download the file needed to successfully install the BPC client on Office 2013. I will continue to search for a trusted and unbiased website. When one turns up, I will update this accordingly.)

Please see below for the steps to successfully install the BPC client on Microsoft Office 2013. I have successfully tested this installation on both the CD Installer, as well as the Microsoft preferred installation method of Office 2013, the Web Installer.

  1. It is imperative that you identify what .NET FRAMEWORK your local machine is using. To be absolutely sure, determine by looking in your Registry Editor using this method You’ll want to be careful while navigating around the registry editor and not change anything. We need to know this for future steps.
  2. You must ascertain that you meet all requirements needed system wide, as well as on your local machine, in order to be able to run the BPC client.
  3. Verify whether you have 32-bit or 64-bit Office 2013 installed. This is a crucial step as we need this information for numerous other steps. You can do this by opening up Excel and  clicking on FILE > ACCOUNT > ABOUT EXCEL. You can easily find what version you have on the first line of the “About Microsoft Excel” window.                             /wp-content/uploads/2014/08/scn1_439327.png
  4. Download the correct version of of the EPM Add-in installer. Again, download your respective version, either 32-bit or 64-bit. Navigate to From here select “B” to filter installation and upgrades by software containing “B” for BPC.
  5. Select SAP BPC FOR SAP NETWEAVER. /wp-content/uploads/2014/08/scn2_439340.png
  6. The following window will ask you if you have BPC 7.5 or BPC 10 installed. Select the proper version your system is running.
  7. You should be at the SAP PLANNING AND CONSOLIDATION X.X, VERSION FOR SAP NETWEAVER info page. Click on SUPPORT PACKAGES AND PATCHES.                                                 /wp-content/uploads/2014/08/scn3_439347.png
  8. Select ENTRY BY COMPONENT.                                                 /wp-content/uploads/2014/08/scn4_439352.png
  9. This is where you need to know what version of the .NET Framework you are using. Make the appropriate selection as dictated by the environment on your local machine.                                                                                                      /wp-content/uploads/2014/08/scn5_439356.png
  10. Expand this tree until you get to WIN32.                                                                                                                             /wp-content/uploads/2014/08/scn6_439358.png
  11. Click on WIN32 to open the DOWNLOADS window from which you will select the most recent client which currently is SP17. /wp-content/uploads/2014/08/scn7_439359.png
  12. Do not install the EPM Add-in yet as you will receive the usual error message of: “THE FOLLOWING COMPONENTS ARE REQUIRED: – MICROSOFT VISUAL BASIC FOR APPLICATION 2013 OR LATER”.
  13. In order to successfully install the EPM add-in we need to install VBA. I used the 2015 AutoCad VBA module available from the AutoCad site.
  14. Navigate to
  15. Select the AutoCad 2015 VBA Module dictated by the needs of your system, either 32-Bit or 64-Bit.
  16. After downloading, extract to a location of your choice. YOU MUST TAKE NOTE OF THIS LOCATION.
  17. If you used the AutoCad VBA download and don’t have AutoCad / AutoDesk installed, you will receive an error message. You will still be able to use the VBA download. Proceed to the next step.
  18. Locate the extraction folder again and open the 3rdParty folder. /wp-content/uploads/2014/08/scn9_439369.png
  19. Open the VBA Folder.                                                         /wp-content/uploads/2014/08/scn10_439370.png
  20. Run the VBA71.msi installer.                        /wp-content/uploads/2014/08/scn11_439372.png
  21. After double clicking you may or may not get confirmation that the VBA Module installed.
  22. Finally, run the EPM Add-in installation file from Step 4. If the EPM Add-in installs without error, this will also confirm that the VBA module installed.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member



      Thanks for this post - it solved the issue I was having.  We are using Office 365 ProPlus and could not get past the VBA requirement.  I was told that VBA is installed with Office 365 ProPlus, but seems this is not the case.


      Interesting as well - after installing VBA from the Autodesk media, it does not show in Add-Remove Programs.


      Thanks for the sleuthing !




      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you for the feedback!

      Author's profile photo Former Member
      Former Member



      Have you tried this with the EPM add-in for the Microsoft Edition of BPC? This post under the "SAP Planning and Consolidation, version for the Microsoft platform" but it is making references to Netweaver.



      Author's profile photo Sri Mallikarjuna Reddy Chemicala
      Sri Mallikarjuna Reddy Chemicala

      Great Cesar, Thanks a ton


      This really helps for I was totally struck with this for  2 days..



      Chemicala SM Reddy

      Author's profile photo Former Member
      Former Member



      Thank you so much. It solved in perfection the issue that I was having.



      Newton Bernardo

      Author's profile photo Former Member
      Former Member

      Thank you for this post!!!

      Author's profile photo Former Member
      Former Member


      A client sent me an excel file (financial model) using  BPC. Here are some instructions that were provided with the file:  "Select desired Business Unit from Current View Action Pane. File will Expand and applicable tabs will populate with BPC data. Once file is populated with BPC data follow steps below: Use Park N Go and set file to "Set to Offline (no connectivity)". Save file to your local PC/ laptop.   You must select "Excel Macro-Enabled Template" as file type. Open file locally outside BPC".

      Attached is a screenshot of what I can see without the BPC add-in.


      I was going to install the EPM add-in (following the above instructions) but I could not download the file because I don't have a log in to connect to the support SAP website (I am not an SAP client).


      Is there a way for me to get this add-in?


      FYI - My setup is:

      Excel 2013 (32 bit)

      .Net Framework 4.5.2



      Thank you very much for your help



      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Sorry Arthur, I'm pretty sure you need to have a proper account to download the tool. Ask your client to provide access to the tool.

      Author's profile photo Bill Challenger
      Bill Challenger

      Hi Folks, I have run across this issue when the end user has Office 365 loaded. If Office 2013 is loaded the issue is resolved.

      Author's profile photo Bjorn Van Damme
      Bjorn Van Damme

      Same when you are running Office 2016. Strange, I understand that Cesar is pointing to Autocad as it has the Vba installer file, but SAP should really look into this. Installing a file from AutoCad to get EPM up and running...

      Author's profile photo Former Member
      Former Member

      Hi Cesar,


      Reports with custom VBA Ribbon fails with below error after installing EPM add-in for office 2013. Using below patch:


      SP25 for SBOP EPM EXCEL CLIENT 10.0

      Error looks like below. Can you help?


      VBA Error.jpg