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.

WD2000: Microsoft Excel Text Formatting May Not Convert When Opened in Word


View products that this article applies to.

This article was previously published under Q211850

↑ Back to the top


Symptoms

When you use Microsoft Word 2000 to open a Microsoft Excel 2000 worksheet with multiple character formats within a cell (for example some text is bold 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 an Excel 2000 worksheet.

↑ Back to the top


Workaround

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

↑ Back to the top


Status

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

↑ Back to the top


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.

↑ Back to the top


References

For additional information about the Microsoft Excel converter forMicrosoft Word, click the article number below to view the article in the Microsoft Knowledge Base:
236051� WD2000: Text Converters Installed During an "Install Now" Setup
For more information about how to open a Microsoft Excel worksheet in Word, click Microsoft Word Help on the Help menu, type how to convert files from another office program in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

NOTE: If the Assistant is hidden, click the Microsoft Word Help button on the Standard toolbar. Install Word Help if it is not already installed on your computer.

For additional information about installing Word Help, click the article number below to view the article in the Microsoft Knowledge Base:
231946� OFF2000: How to Add/Remove a Single Office Program or Component

↑ Back to the top


Keywords: KB211850, kbnofix, kbinterop, kbbug

↑ Back to the top

Article Info
Article ID : 211850
Revision : 3
Created on : 5/28/2003
Published on : 5/28/2003
Exists online : False
Views : 332