XL2000: Next Comment and Previous Comment Tools May Not Work (214347)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q214347

SYMPTOMS

In Microsoft Excel 2000, if you click the Next Comment or Previous Comment tool on the Reviewing toolbar, the next or previous comment in the worksheet may not appear on the screen.

CAUSE

This behavior can occur when the following conditions are true:
  • You have hidden all objects from view by following these steps:
    1. On the Tools menu, click Options, and then click the View tab.
    2. Under Objects, click Hide all, and then click OK.
    -and-

  • You have deleted a comment from the worksheet by one of the following methods:
    • Right-click the cell, or press CTRL and click the cell, and then click Delete Comment on the shortcut menu.

      -or-

    • Click the Delete Comment tool on the Reviewing toolbar.
When you click the Next Comment or Previous Comment tool, the status bar displays the cell address and the name of the user who entered a comment. However, the comment itself does not appear.

WORKAROUND

To work around this issue, follow these steps:
  1. On the Tools menu, click Options, and then click the View tab.
  2. Click Show all, and then click OK.
The comments appear correctly when you click the Next Comment or Previous Comment tool.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

In Microsoft Excel 2000, you can use the tools on the Reviewing toolbar to work with comments in a worksheet.

Because comments are similar to drawing objects, the displaying of comments is affected when you click Hide all on the View tab of the Options dialog box. As long as you do not delete any comments, you can use the tools on the Reviewing toolbar to browse through the comments in a worksheet.

However, after you delete a comment, you must cancel the selection of Hide all. If you do not do this, the Reviewing tools do not work correctly. This issue persists until you quit and restart Microsoft Excel.
Modification Type:MajorLast Reviewed:9/27/2003
Keywords:kbbug kbpending KB214347
©2003 Microsoft Corporation. All rights reserved.