XL: Note or Comment Doesn't Appear When Cell Is in PivotTableLast reviewed: February 5, 1998Article ID: Q179299 |
The information in this article applies to:
SYMPTOMSIn the versions of Microsoft Excel listed at the beginning of this article, the following problems may occur:
CAUSEThese problems occur if the cell that contains the note or comment also contains a PivotTable row field, column field, or page field. These fields usually appear as shaded "buttons" in a PivotTable.
WORKAROUNDAlthough the note or comment and its indicator do not appear in the cell, you can view the note or comment by editing it.
Microsoft Excel Versions 7.0 and 7.0aTo work around this problem, follow these steps:
Microsoft Excel 97 and Microsoft Excel 98 Macintosh EditionTo work around this problem, follow these steps:
STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
MORE INFORMATIONIn the versions of Microsoft Excel listed at the beginning of this article, you can insert a note or a comment into a cell by selecting the cell and clicking either Note or Comment on the Insert menu. You can edit an existing note or comment by selecting the cell and clicking either Note or Edit Comment on the Insert menu. Usually, when you insert a note or a comment into a cell, a small red marker appears in the upper right corner of the cell, and the note or comment appears on the screen when you move the mouse pointer over the cell. However, if the cell contains a PivotTable field, the indicator does not appear, and the note or comment does not appear when you move the pointer over the cell.
|
Additional query words: XL7 XL97
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |