Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/171894

From BetaArchive Wiki
Knowledge Base

XL97: Comment Formatting May Be Lost When You Share a Workbook

Article ID: 171894

Article Last Modified on 10/21/2000


  • Microsoft Excel 97 Standard Edition

This article was previously published under Q171894


In Microsoft Excel 97, when you open a workbook, some of the formatting that is applied to a cell comment in the workbook is lost.


This problem occurs if you share the workbook by clicking Share Workbook on the Tools menu and selecting the check box in the Editing tab of the Share Workbook dialog box.

If the workbook is shared and you save and close the workbook, certain kinds of formatting that is applied to comments are not retained.


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


In Microsoft Excel 97, you can apply many kinds of formatting to text in a cell comment. However, when you share a workbook, only bold and italic comment formatting is retained. When you save and close a shared workbook, all of the following formatting is lost:

   Font Size
   Font Color
   Double Underline

If you unshare the workbook, all comment formatting is retained when you save and close the workbook.

Additional query words: XL97

Keywords: kbbug KB171894