Deleting Essbase Cell Comments

Be sure to complete the steps in Enabling Essbase Cell Comments.

  To delete Essbase cell comments:

  1. If you have not already done so, open a workbook containing a grid, connect to an Essbase provider, and click Refresh.

  2. Click View Comments in the Essbase ribbon (see Figure 17, View Comments Command in Essbase Ribbon.

    The Comment Edit dialog box is launched. The example in Figure 23, Comment Edit Dialog Box shows one comment left on the sheet, which can be removed.

    Figure 23. Comment Edit Dialog Box

    The Comment Edit dialog box, showing one comment, which can be removed.
  3. To delete the entire comment, first click in the row to highlight the editable text; for example, click in the “Oregon Coast” row to highlight it, as shown in Figure 24, Cell Comment Highlighted and Ready to be Deleted, then press the Delete key.

    Figure 24. Cell Comment Highlighted and Ready to be Deleted

    Cell comment highlighted and ready to be deleted in Comment Edit dialog box.

    After deletion, the text in the Comments column is removed, but the Cell ID is still displayed (see Figure 25, Cell Comment Deleted, Cell ID Remaining

    Figure 25. Cell Comment Deleted, Cell ID Remaining

    The cell comment is deleted from the Comment Edit dialog box, the Cell ID remains.
  4. Click Apply Changes and view the changes in the sheet.

    In Figure 26, Sheet After Clicking Apply Changes; Cell F5 Still Commented , cell F5 still shows as a commented cell, and will until the sheet is refreshed.

    Figure 26. Sheet After Clicking Apply Changes; Cell F5 Still Commented

    Grid After Clicking Apply Changes; Cell F5 Still Commented
  5. Click Refresh; the comment style is cleared.

    Figure 27. Grid After Refresh, Cell Style in Cell F5 Is Cleared

    After Refresh, the cell style on cell F5 is now cleared.