Viewing Comments in the Sheet

You can view comments in an ad hoc sheet.

To view comment cells in an ad hoc sheet:

1. Be sure to complete the steps in Enabling Comment Display in the Sheet
2. Start an ad hoc grid or open a workbook containing a grid and click Refresh.
3. On the sheet, note the cells containing comments and unknown members.

   In the example shown below, cell B6 is an unknown member and Smart View marked the cell as a comment. The member name was probably changed in the underlying cube. The comment style indicates to us that this member needs attention.

   Figure 10-10 Grid Showing Cells Marked with Comment Style

   

   Additionally, a comment in column G notes that the member name is incorrect (G5). This comment is a note someone made outside of the grid and confirms to us that the member name has been changed in the cube and that the member needs to be manually updated in the grid. Another comment outside of the grid (G3), provides general instructions about the grid.

4. Continue with Editing and Deleting Comments and Unknown Members.