Select the product you need help with

Paragraph Inserted with Paste Linked Spreadsheet from Excel

Article ID: 75717 - View products that this article applies to.

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.

Back to the top | Give Feedback

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.

Back to the top | Give Feedback

WORKAROUND

To reduce the spacing around the inserted paragraph, use the following steps:

Position the insertion point to the left of the paragraph mark. (You cannot select the mark only.)
On the Format menu, click Paragraph.
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

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

Note: If the field codes are displaying rather than the desired information, clear the Field Codes command by:

Click Options on the Tools menu and select the View tab.
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

Back to the top | Give Feedback

Properties

Article ID: 75717 - Last Review: November 16, 2006 - Revision: 2.2

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 Word for Windows 2.0b
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

kbfield kbtable kbusage KB75717

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top | Give Feedback