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

Last reviewed: February 2, 1998
Article ID: Q178672
The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition

SYMPTOMS

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

CAUSE

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.

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, 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
   Font Size
   Font Color
   Underline
   Double Underline
   Strikethrough
   Superscript
   Subscript

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


Additional query words: XL98
Keywords : xlformat
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbbug
Solution Type : kbpending


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.