SAP Knowledge Base Article - Public

2797159 - AO 2.x: How to show or hide the Cut, Copy & Paste entries in the Context Menu


When opening the Context Menu for a cell that belongs to an AO data source, Analysis Office does hide most of the Excel native context menu entries. This includes the entries Cut, Copy & Paste.

Context Menu.png

This KBA is relevant for you in case that your users need to be able to use the Cut, Copy & Paste functionalities on AO cells through the Context Menu.

Until AO 2.7 SP6 the Paste Menu ("Paste Options") was an exception and displayed anyway, because it was not possible to hide it due to technical limitations. This has been changed with the correction of SAP Note 2775946.


SAP Analysis for Microsoft Office 2.7


You can use the setting "ShowCutCopyPasteInGridContextMenu" to show the native Excel context menu entries "Cut, Copy & Paste" in the Context Menu.

Settings AO.png

After enabling the setting, AO will show the Cut, Copy & Paste entries in the Context Menu.


Refer to SAP Note 2083067 in order to know how to change the settings in Analysis Office.

See Also

SAP Note 2775946 - AO: Paste Options Menu is not hidden in AO Context Menu

SAP Note 2083067 - How to maintain settings for Analysis Office 2.x


AO; Analysis Office; Context Menu; Cut; Copy; Paste; Paste Special; Right Click , KBA , BI-RA-AO-XLA , Excel Addin , Problem


SAP Analysis for Microsoft Office all versions