Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Comment formatting may be lost when you share a workbook


View products that this article applies to.

Symptoms

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

↑ Back to the top


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.

↑ Back to the top


Workaround

There is currently no workaround for this problem.

↑ Back to the top


Status

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

↑ Back to the top


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

↑ Back to the top


Keywords: KB211717, kbpending, kbbug

↑ Back to the top

Article Info
Article ID : 211717
Revision : 5
Created on : 1/23/2007
Published on : 1/23/2007
Exists online : False
Views : 39