SAP Knowledge Base Article - Public

2781788 - No question mark icon for value help for planning cells in Protected Workbooks

Symptom

The Analysis for Office workbook is protected and you are trying to call the Value Help for a Planning Cell in New Lines context.  The question mark '?' cell icon is not displayed.

Environment

SAP Analysis for Office 2.x

Reproducing the Issue

1. Open a protected a planning workbook in Analysis for Office.
2. Click on a cell in the new lines and the question mark '?' does not appear.

Cause

For protected workbooks Analysis Office deliberately does not show the value help icon (the '?') because this costs a lot of performance as we would need to unprotect the workbook then show the icon and finally protect the workbook again.

Resolution

If the workbook is protected you need to use the F4 key to popup the value help (as the icons are not rendered). There are currently no plans to change this.

See Also

If even the F4 key does not display the value help, see note 2662408.

If the selected value from the value help is not applied to the cells, see note 2534569.

Keywords

Analysis for Office, AO, Value Help, F4, Key, Planning, New Lines, Text, Keyfigure, Characteristic, Question Mark, Missing, '?' , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office 2.6 ; SAP Analysis for Microsoft Office 2.7 ; SAP BusinessObjects Analysis 2.0, edition for Microsoft Office ; SAP BusinessObjects Analysis 2.1, edition for Microsoft Office ; SAP BusinessObjects Analysis 2.2, edition for Microsoft Office ; SAP BusinessObjects Analysis 2.3, edition for Microsoft Office ; SAP BusinessObjects Analysis 2.4, edition for Microsoft Office ; SAP BusinessObjects Analysis for Microsoft Office 2.5