3405308 - Analysis for Office crashes after Trellix update with Exception from HRESULT: 0x800706BE

One of the below error messages are displayed when launching an Analysis Office workbook from .sapaox file or when trying to launch Analysis Office:

• Exception Processing Message 0xc0000005 - Unexpected prameters
  
  
  
• The remote procedure call failed. (Exception from HRESULT: 0x800706BE)

The last lines of the AO_Trace file (refer to SAP Note 2129389) show the list of available AO plugins and nothing else:
-----------------------------------------------
Trying to find plugins at path C:\Program Files\SAP BusinessObjects\Office AddIn\Plugins\ with expression *Plugin.dll 
found the following excel plugins 
Id: com.sap.ip.bi.pioneer 
Id: com.sap.epm.BPFClient 
-----------------------------------------------

If Excel crashes, the following error can be seen in the Windows Event Log following the application crash:
-----------------------------------------------
Application: EXCEL.EXE
Framework Version: v4.0.30319
"The process was terminated due to an internal error in the .NET Runtime at IP ... with exit code 80131506."
-----------------------------------------------

Event viewer can also show:
-------------------------------------------------------
Faulting application path: C:\Program Files\Microsoft Office\Root\Office16\EXCEL.EXE
Faulting module path: C:\Windows\Microsoft.NET\Framework64\v4.0.30319\clr.dll
-----------------------------------------------

• SAP Analysis for Microsoft Office
• Trellix Endpoint Security

1. Install Trellix Endpoint Security 10.7 September 2023 Update.
2. Download and open an Analysis for Office report that creates a .sapaox launcher (e.g. open a report from browser or from transaction RAAOE) or try to launch Analysis Office application;
3. Excel opens with the above errors.

3rd party program

This is not an SAP bug. Certain applications using .NET runtime crash after this Trellix update.
See their article for the fix:
https://kcm.trellix.com/corporate/index?page=content&id=KB96789

Workaround 1:

1. Make sure the LoadBehavior of AO is set to 0 (refer to KBA 2440829);
2. Make sure that the add-in is not disabled in Excel (File > Options > Add-ins, select "Disabled Items", click on "Go" and make sure that AO is not in the list);
3. Start Excel;
4. Manually enable AO via Excel File > Options > Add-ins, select "COM Add-ins", click on "Go" and select "Analysis";

Workaround 2:

1. Install Windows updates: KB5034123, KB5033920, KB5033734;
2. Install MS 365 Apps update: 16.0.16130.20884;
3. AO can now be used with LoadBehavior set to 3;

0xc0000005, 0x800706BE, Trellix, Analysis Office, sapaox, businessobjects, excel, raaoe, clr.dll, loadbehavior
, KBA , BI-RA-AO-XLA , Excel Addin , Problem