Pasting a Microsoft Excel Worksheet Object Into a Word Document

[WFC_Exile]

Just spent way to long trying to 'paste special' a Microsoft Excel Worksheet Object into a Word 2000 document.

The pasted Object was behaving strangely when I tried to format it. The reason turned out to be that the pasted item winds up in the header field of the Word document - no matter what I do. View Header/Footer is not active - it just goes there.

Pasting into Word as RFT or unformatted text - it goes into the proper part of the doc - but not the Microsoft Excel Worksheet Object. Can anyone explain why this is happening and how I get it out of the header and onto the body of the document?

[TJolly]

Hi

This may work.

On the word doc goto insert>file and navigate to the xls file and double click.

[WFC_Exile]

TJolly,

Thanks - but no joy. That operation tries to put the entire contents of the Excel file into the Word doc. I'm need to put sections into the clean-looking format one gets when using the Worksheet Object method - I just need it to not be in a giant header.

[TJolly]

Soory couldn't help

[comp_see]

In Excel, select the cells to be copied and click Copy icon.

In Words, click Edit / Paste Special
In the Paste Special dialog box, select Paste and MS Excel Worksheet Object then click OK.

The copied object can be moved anywhere when you move the cursor in the object and see the 4-arrow cursor. If not, right click it and select Format Object. In the position tab, check Float over object.

[Dreamboat]

WFC: If no other suggestions work, can you try pasting it into a brand new document? If NOT, then there's something wrong with Word. Here are steps to troubleshoot that:
www.theofficeexperts.com/word.htm

Now. If it DOES work in a new document, then perhaps there's something wrong with your existing document. Can you paste anything ELSE into the document without it going into the header/footer area? Where is the placement of your cursor when you choose paste? What happens AFTER pasting, if you right-click and choose Format-Object, then the Layout tab, and choose Inline with Text?

[WFC_Exile]

Hi All,

Actually comp_see had the fix - it worked. it was my own lack of knowledge about handling 'Objects'


Thanks comp_see &
Thanks to all for responding.