SAP Knowledge Base Article - Public

2735113 - Analysis for Office crashes in case of freeze panels


If you use Excel function Freeze Panels in Analysis Office workbook, Analysis Office crashes when you move the corsur around with keyboard and mouse.


SAP Analysis for Microsoft Office

Reproducing the Issue

  1. Execute the Analysis Office workbook
  2. Lock the cells using Excel function in View -> Freeze Panels
  3. Use the keyboard <- key, move the corsur to the left end
  4. Click on another cell with the mouse


This issue is caused by some misbehavior of the Microsoft Excel APIs when they area called from Analysis Office workbook.


Note: The workaround is only provided to help the affected users to be able to work again, but in general this is is not a generally recommended solution, as it turns off some AO functionalities like "Drag & Drop" to move characteristics on the crosstab and clicking the hierarchy icons to expand/collapse them.
If you need final solution and documentation, please contact Microsoft Support.

Workaround: Add parameter "TurnOffWindowsHooking" to your PC at administrator level and set the value to "True".

  1. Navigate to the folder %PROGRAMDATA%\Sap\Cof and open Ao_app.config file
  2. Add the parameter

    <section name="TurnOffWindowsHooking" type="Boolean" configurationLevel="UserRoaming" />

    <TurnOffWindowsHooking value="True" />

  3. Save the Ao_app.config file

You can also refer to KBA 2083067 regarding how to add the settings at administrator level.
(see example "Examples: how to maintain Analysis Office settings at administrator level" --> "3. ShowApplyNumberFormatsToggleButton")


Anslysis Office, Excel, workbook, crash, Freeze Panel, corsur, keyboard, drag and drop , KBA , BI-RA-AO-XLA , Excel Addin , Problem


SAP Analysis for Microsoft Office all versions