Paste Excel document in Word

[Palagast]

Hi all,

When I past an Excel(97) document into a Word(97) document (either with insert object or with cut and paste special), the Excel document inserts fine. However, when I print it, the lines between the cells are printed as well, something that I don't want. The lay-out does include some lines that must stay there, but in the current document all the borders between cells are shown.
I'm sure there is a way to resolve this, I just don't know how...

Thanks in advance.

 

[Dreamboat]

Are you linking or is it pasting in as a Word table? If you're linking, then you need to turn off printing of gridlines in the Excel file.

Anne Troy
Supercharge your Office Applications:

http://www.vbaexpress.com

 

[Palagast]

Dreamboat,

Thanks for your reply. I paste it like a linked document. In Excel the setting Print Borderlines is turned off. When you look at it in Excel, it doesn't show the borderlines at a print preview, just when you link it in Word.
Any other suggestions?
Thanks

 

[Dreamboat]

That's bizarre. So you can't see the gridlines in the Excel file? Make sure you turn off viewing gridlines too.

Anne Troy
Supercharge your Office Applications:

http://www.vbaexpress.com

 

[macropod]

If you psate an Excel Object into Word, then open the object for editing, the gridlines will then show in both the object and in Word unless you use Tools|Options|View and uncheck the 'gridlines' option.

Cheers

 

[Palagast]

The person who had this problem solved it some way and I don't know how
When I speak her again I'll ask and post what did the trick.
Thanks for your help ppl.