How To Fix RSR_EXCEL_RUNTIME114 - Access to Visual Basic project denied

SAP Error Message - Details

• Message type: E = Error

• Message class: RSR_EXCEL_RUNTIME - Messages of the Excel Runtime

• Message number: 114

• Message text: Access to Visual Basic project denied

What causes this issue?

When 3.x workbooks are upgraded, the VBA code in the workbooks is
checked to identify whether any 3.x BEx Analyzer APIs are used in the
code and whether they need to be upgraded to the new APIs. This check
requires access to the VBA project in Excel. Since access is denied,
this activity is not carried out.

System Response

The 3.x BEx Analyzer APIs cannot be upgraded. This is only relevant if
you have used APIs in the VBA code of the workbook and these APIs need
to be upgraded.

How to fix this error?

This is only relevant if you have used 3.x BEx Analyzer APIs in the 3.x
workbook that is being upgraded. The 3.x APIs are not upgraded and this
may lead to runtime errors when the workbook is executed.
To grant trusted access to Visual Basic project in Excel, proceed as
follows:
Open Microsoft Excel. Choose <ZK>Tools</> --> <ZK>Macro</> -->
<ZK>Security</>.
Choose the <ZK>Trusted Publishers</> tab page.
Select <ZK>Trust access to Visual Basic Project</>.
If you are not authorized to do this, contact your system administrator.

Procedure for System Administrators

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSR_EXCEL_RUNTIME114 - Access to Visual Basic project denied ?

  The SAP error message RSR_EXCEL_RUNTIME114: Access to Visual Basic project denied typically occurs when you are trying to export data from SAP to Excel, and the Excel file is either protected or has certain security settings that prevent access to the Visual Basic for Applications (VBA) project. This can happen in various scenarios, such as when using SAP Business Explorer (BEx) Analyzer or other SAP tools that interact with Excel.
  Cause:
  
  Excel File Protection: The Excel file you are trying to use may be protected, preventing access to the VBA project.
  Macro Security Settings: Excel's macro security settings may be set to a level that restricts access to the VBA project.
  Excel Version: Certain versions of Excel may have different security settings or restrictions that can lead to this error.
  Missing Permissions: The user may not have the necessary permissions to access the VBA project in the Excel file.
  
  Solution:
  To resolve the RSR_EXCEL_RUNTIME114 error, you can try the following steps:
  
  
  Check File Protection:
  
  Open the Excel file and check if it is protected. If it is, you may need to unprotect it by going to the "Review" tab and selecting "Unprotect Sheet" or "Unprotect Workbook".
  
  
  
  Adjust Macro Security Settings:
  
  Open Excel and go to File > Options > Trust Center > Trust Center Settings.
  In the Trust Center, go to Macro Settings and ensure that the option "Disable all macros with notification" or "Enable all macros" is selected. Avoid "Disable all macros without notification" as it may restrict access to VBA projects.
  
  
  
  Check for Add-ins:
  
  Sometimes, Excel add-ins can interfere with the operation. Disable any unnecessary add-ins and try again.
  
  
  
  Repair Office Installation:
  
  If the issue persists, consider repairing your Office installation. Go to Control Panel > Programs > Programs and Features, select Microsoft Office, and choose the repair option.
  
  
  
  Check User Permissions:
  
  Ensure that you have the necessary permissions to access the VBA project. If you are in a corporate environment, you may need to contact your IT department for assistance.
  
  
  
  Use a Different Excel Version:
  
  If possible, try using a different version of Excel to see if the issue persists.
  
  
  
  Related Information:
  
  SAP Notes: Check SAP Notes for any specific patches or updates related to this error. SAP frequently updates its software, and there may be specific fixes available.
  Excel Documentation: Refer to Microsoft’s documentation for more information on macro security settings and VBA project access.
  SAP Community: Engage with the SAP Community forums for additional insights and solutions from other users who may have encountered the same issue.
  
  By following these steps, you should be able to resolve the RSR_EXCEL_RUNTIME114 error and successfully export data from SAP to Excel.