Microsoft KB Archive/177191

= Next Comment and Previous Comment Tools May Not Work =

Article ID: 177191

Article Last Modified on 8/19/2003

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q177191





SYMPTOMS
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 problem may occur when the following conditions are true:

 You have hidden all objects from view by following these steps:

 On the Tools menu, click Options or Preferences. Click the View tab. Under Objects, click Hide All, and then click OK.

-and-

 You have deleted a comment from the worksheet by right-clicking the cell or by pressing CONTROL and clicking the cell, and then clicking Delete Comment on the shortcut menu, or by clicking 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.

<div class="workaround_section">

WORKAROUND
To work around this problem, follow these steps:


 * 1) On the Tools menu, click Options or Preferences. Click the View tab.
 * 2) Click Show All or Show Placeholders, 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 this to be a problem in the Microsoft products listed at the beginning of this article.

<div class="moreinformation_section">

MORE INFORMATION
You can use the tools on the Reviewing toolbar to work with comments in a worksheet.

Because comments are similar to drawing objects, displaying comments is affected when you click Hide All in 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, once 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 problem continues until you quit and restart Microsoft Excel.

Additional query words: XL97 XL

Keywords: kbbug KB177191

-

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

© Microsoft Corporation. All rights reserved.