How To Fix RSR_EXCEL_RUNTIME102 - Access to Visual Basic project denied

RSR_EXCEL_RUNTIME102 - Overview

• Message type: E = Error

• Message class: RSR_EXCEL_RUNTIME - Messages of the Excel Runtime

• Message number: 102

• Message text: Access to Visual Basic project denied

What causes this issue?

The BEx Analyzer cannot generate VBA code due to the security settings.

System Response

VBA code is not generated.

How to fix this error?

Choose <ZK>Tools</> -> <ZK>Macro</> -> <ZK>Security</>.
On the <ZK>Trusted Publishers</> tab page, select <ZK>Trust access to
Visual Basic project</>.
Choose OK.
Close the BEx Analyzer and continue working as before.

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

Access to Visual Basic project is only needed when generating VBA code.
This only takes place in design mode or when 3.x workbooks are upgraded.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

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

  The SAP error message RSR_EXCEL_RUNTIME102: Access to Visual Basic project denied typically occurs when you are trying to export data from SAP BW (Business Warehouse) to Excel, and there is an issue with the Excel settings or the security settings of the Visual Basic for Applications (VBA) environment.
  
  Cause:
  
  
  Excel Security Settings: The error often arises due to the security settings in Excel that prevent access to the Visual Basic project. This can happen if the macro settings are set to "Disable all macros without notification" or if the workbook is opened in a mode that restricts access to the VBA project.
  
  
  Protected Workbook: If the Excel workbook is protected or if the VBA project is locked with a password, you will not be able to access it.
  
  
  Excel Version Compatibility: Sometimes, compatibility issues between different versions of Excel and SAP can lead to this error.
  
  
  
  Solution:
  To resolve the RSR_EXCEL_RUNTIME102 error, you can try the