Microsoft KB Archive/169879

= WD97: MS Excel Text Formatting May Not Convert Properly to Word =

Article ID: 169879

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Word 97 Standard Edition

-



This article was previously published under Q169879



SYMPTOMS
When you use Microsoft Word 97 to open a Microsoft Excel 97 worksheet with multiple character formats within a cell (for example some text is bolded and other text is italic), all text in that cell uses the format of the first character. All other formatting is lost.

NOTE: This problem also occurs when you use the File command on the Insert menu in Word to insert a Microsoft Excel 97 worksheet.



WORKAROUND
To work around this problem, copy the worksheet in Microsoft Excel 97, and then paste it into Word. This method preserves all character formatting.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Word 97 for Windows.



MORE INFORMATION
Earlier versions of Microsoft Word and Microsoft Excel convert rich text formats accurately. The problem is due to changes in the Microsoft Excel binary interchange file format (BIFF) definitions.

For additional information about the Microsoft Excel converter for Microsoft Word, please see the following article in the Microsoft Knowledge Base:

157084 WD97: Text Converters Installed in a Typical Setup

For more information about how to open a Microsoft Excel worksheet in Word, click the Office Assistant, type Excel converter, click Search, and then click to view the "How to Import or convert files from another Office program" topic.

NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If Word Help is not installed on your computer, please see the following article in the Microsoft Knowledge Base:

120802 Office: How to Add/Remove a Single Office Program or Component

Additional query words: 8.0

Keywords: kbbug kbinterop KB169879

-

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

© Microsoft Corporation. All rights reserved.