Microsoft KB Archive/211717

= Comment formatting may be lost when you share a workbook =

Article ID: 211717

Article Last Modified on 1/23/2007

-

APPLIES TO


 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 2004 for Mac
 * Microsoft Excel X for Mac
 * Microsoft Excel 2001 for Mac
 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q211717



SYMPTOMS
When you open a workbook, some of the formatting that you applied to a cell comment in the workbook is lost.



CAUSE
This problem occurs if the workbook is shared.

NOTE: To share a workbook, click Share Workbook on the Tools menu. On the Editing tab, click to select the Allow changes by more than one user at the same time check box and click OK.



WORKAROUND
There is currently no workaround for this problem.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.



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

Font

Font Size

Font Color

Underline

Double Underline

Strikethrough

Superscript

Subscript

Additional query words: XL2000

Keywords: kbbug kbpending KB211717

-

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

© Microsoft Corporation. All rights reserved.