3197528 - "The remote procedure call failed. (Exception from HRESULT: 0x800706BE)" and "BiXllFunctions registration failed." when starting Analysis Office

The error below occurs when trying to start Analysis Office:
------------------------------------------
The remote procedure call failed. (Exception from HRESULT: 0x800706BE)
------------------------------------------

The entries below can be found in AO traces (refer to SAP Note 2129389):
------------------------------------------
General .NET Exception [aa3e-cbf1-f8]:
BiXllFunctions registration failed. Path: C:\Program Files (x86)\SAP BusinessObjects\Office AddIn\Plugins\AnalysisOffice\BiXLLFunctions.dll
at com.sap.ip.bi.pioneer.excel.main.EaOfficeAddin.Startup()

System.Runtime.InteropServices.COMException (0x800706BE): The remote procedure call failed. (Exception from HRESULT: 0x800706BE)
bei Com.Sap.Cof.Interfaces.COM.ISapCofComObject.ActivatePlugin(String iPluginName)
bei Com.Sap.Cof.Launcher.OfficeGetterHelper.ActivatePlugin(ISapCofComObject comObject, String pluginId)
bei Com.Sap.Cof.Launcher.OfficeGetterHelper.ActivatePlugin(ICOMAddIn pioneerAddIn, Boolean analysisPlugin, Boolean epmPlugin)
bei Com.Sap.Cof.Launcher.LauncherApplication.StartApplication(OfficeGetterHelper officeGetterHelper, IOfficeApplication& officeApplication, ICOMAddIn& comAddIn, Boolean& officeIsReused)
bei Com.Sap.Cof.Launcher.LauncherApplication.StartApplicationAndCallCOM(OfficeGetterHelper officeGetterHelper)
bei Com.Sap.Cof.Launcher.Launcher.Main(String[] args)
------------------------------------------

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

SAP Analysis for Microsoft Office

1. Try to start Analysis Office;
2. The error is shown and AO is not started;

The Excel version is not supported or Visual Basic for Applications (VBA) is disabled. VBA is a prerequisite for running AO.

• Make sure that the Excel version installed in the machine is a supported version according to Microsoft's page Update history for Microsoft 365 Apps (listed by date). The Excel version can be found via Excel -> File -> Account as shown below:
  

  

• There are several ways that VBA might be disabled. See this page from Microsoft Learn. VBA enablement can be checked in the Developer ribbon of Excel. The Visual Basic button has to be enabled:
  

 Microsoft Learn page about enabling/disabling VBA

0x800706BE, aa3e-cbf1-f8, 365 , KBA , BI-RA-AO-XLA , Excel Addin , Problem