Symptom
In Analysis ribbon, the buttons in Comments group are disabled.
It is required more information about the Comments in Analysis Office.
Environment
SAP Analysis for Microsoft Office
Resolution
Excel for Office 365 has two kind of comments: the new threaded comments, and the old ones, now called "Notes". More information can be found in Microsoft's page "The difference between threaded comments and notes".
The Analysis Office comments feature works only in conjunction with the old comments (now "Notes"). It is not possible to use threaded comments and use them as e.g. BW comments in AO.
In order to comment a data cell in Analysis Office:
- Make sure the option "Comments Storage" is set accordingly in File > Analysis > Customize Analysis > Options > Platform (this option is controlled by setting PreferredDocumentStorage and the default is "Business Warehouse");
- To save comments in Business Warehouse, refer to chapter "To save comments in SAP BW/4HANA";
- To save comments in Business Intelligence Platform, refer to chapter "To save comments on the BI platform";
- To save comments locally in the workbook, refer to chapter "To save comments locally in the workbook";
- Make sure the data source is already refreshed;
- Follow the instructions of chapter "To comment a data cell";
For normal Excel comments, go to the Review ribbon and use the options in Notes menu as shown below:
See Also
Chapter "Commenting data cells"
Keywords
comments, comment, commentary, disabled, greyed out , KBA , BI-RA-AO-XLA , Excel Addin , BI-RA-AO-BIP , AO Precalculation, Scheduling and AO InfoOb... , How To