Paragraph Inserted with Paste Linked Spreadsheet from Excel

ID: Q75717

The information in this article applies to:

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" (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):

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

KBCategory: kbusage fixlist7.0 KBSubcategory: kbfield kbtable Additional query words: word6 winword winword2

Keywords          : kbusage kbfield kbtable 
Version           : 1.x 2.x 6.0 6.0a 6.0c
Platform          : WINDOWS

Last Reviewed: February 6, 1998