Microsoft KB Archive/211667

= XL2000: Comment Changes Are Not Saved in Shared Workbook =

Article ID: 211667

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q211667





SYMPTOMS
If you edit a comment on a cell, changes to the comment may be lost when you select any other cell in the worksheet.



CAUSE
This behavior may occur when all of the following conditions are true:
 * You share the workbook by clicking Share Workbook on the Tools menu.

-and-
 * You have the workbook displayed in two or more windows.

-and-
 * When you are editing the comment, the comment is visible in two or more windows.



WORKAROUND
To work around this problem, use any of the following methods.

Have the Comment Visible in Only One Window
Make sure that the comment is visible only in one window when you edit it. To do this, use any of the following methods:
 * Minimize any windows that display the same workbook.

-or-
 * Close any windows that display the same workbook.

-or-
 * Scroll through any windows that display the same workbook, so that they do not display the comment.

-or-
 * Hide any windows that display the same workbook by clicking Hide on the Window menu, or by moving some other window in front of them.

Press ESC Before You Change the Comment
If you press ESC before you actually make any changes to the comment, the changes are retained when you select any other cell in the worksheet.

Do Not Share the Workbook
You can also prevent this problem from occurring by not sharing the workbook. To do this, follow these steps:
 * 1) On the Tools menu, click Share Workbook.
 * 2) On the Editing tab, click to clear the Allow Changes check box, and then click OK.

Note that if you perform these steps, other users can no longer make changes to the workbook when you have it open.



STATUS
Microsoft has confirmed that this is a problem in Excel 2000.



MORE INFORMATION
You can share a workbook so that multiple users can simultaneously make changes to the workbook. To share a workbook, click Share Workbook on the Tools menu, click to select the Allow Changes check box, and then click OK.

You can also insert a comment in a cell in a worksheet. To do this, select the cell that you want to comment, and click Comment on the Insert menu. To edit existing comments, select the cell that contains the comment and click Edit Comment on the Insert menu, or right-click the cell and then click Edit Comment on the shortcut menu.

Additional query words: XL97 cell notes XL2000

Keywords: kbbug kbpending KB211667

-

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

© Microsoft Corporation. All rights reserved.