Microsoft KB Archive/75717

= Paragraph Inserted with Paste Linked Spreadsheet from Excel =

Article ID: 75717

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Word 1.0 Standard Edition
 * Microsoft Word 1.1 Standard Edition
 * Microsoft Word 1.1 Standard Edition
 * Microsoft Word 2.0 Standard Edition
 * Microsoft Word 2.0a
 * Microsoft Office Word 2003
 * Microsoft Word 2.0c
 * Microsoft Word 6.0 Standard Edition
 * Microsoft Word 6.0a
 * Microsoft Word 6.0c
 * Microsoft Word 95a
 * Microsoft Word 97 Standard Edition

-



This article was previously published under Q75717





SYMPTOMS
If you bring a Microsoft Excel spreadsheet into a Microsoft Word for Windows document using the Paste Link, Formatted Text (RTF), a blank paragraph is inserted above the table. The paragraph mark cannot be selected or deleted; however, the spacing can be reduced. The blank paragraph does not appear if you bring the spreadsheet into Word for Windows using the regular Paste command.



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.



WORKAROUND
To reduce the spacing around the inserted paragraph, use the following steps:
 * 1) Position the insertion point to the left of the paragraph mark. (You cannot select the mark only.)
 * 2) On the Format menu, click Paragraph.
 * 3) Under Line Spacing, make sure it is set to Single. Under AT, type .01&quot; (in Word version 6.0) or -0.04 li or -0.01 (in Microsoft Word version 2.0 and prior.)

Steps to Reproduce Problem

 * 1) Create a spreadsheet in Microsoft Excel.
 * 2) Select a range of cells to insert into Microsoft Word for Windows.
 * 3) On the Edit menu, click Copy.
 * 4) Start Microsoft Word for Windows. On the Edit menu, click Paste Link, Formatted Text (RTF).
 * 5) Click OK.

Note: If the field codes are displaying rather than the desired information, clear the Field Codes command by:
 * 1) Click Options on the Tools menu and select the View tab.
 * 2) Clear the Field Codes check box.

Microsoft Word 1.x, also verify that the Show All option is not selected in the Preferences dialog box.

A blank paragraph is inserted immediately above the table. This paragraph is not present if the field codes are displayed.

Reference(s):

&quot;Microsoft Word for Windows User's Reference,&quot; version 1.x, pages 178-179

Additional query words: word6 winword winword2

Keywords: kbtable kbfield kbusage KB75717

-

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

© Microsoft Corporation. All rights reserved.