Microsoft KB Archive/178603

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

Article ID: 178603

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q178603



SYMPTOMS
In Microsoft Excel 98 Macintosh Edition, if you edit a comment in a cell, the changes to the comment may be lost when you select any other cell in the worksheet.



CAUSE
This problem 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 prevent this problem from occurring, 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 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 by not sharing the workbook. To do this, follow these steps:


 * 1) Click Share Workbook on the Tools menu.
 * 2) Click the Editing tab.
 * 3) Clear (uncheck) the Allow Changes check box, and then click OK.

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



STATUS
Microsoft 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 INFORMATION
In Microsoft Excel 98 Macintosh Edition, 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: XL98 cell notes

Keywords: kbbug KB178603

-

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

© Microsoft Corporation. All rights reserved.