Microsoft KB Archive/214347

= XL2000: Next Comment and Previous Comment Tools May Not Work =

Article ID: 214347

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



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:  On the Tools menu, click Options, and then click the View tab. 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-

</li> Click the Delete Comment tool on the Reviewing toolbar.</li></ul> </li></ul>

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.

<div class="workaround_section">

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.

<div class="status_section">

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

<div class="moreinformation_section">

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.

Keywords: kbbug kbpending KB214347

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.