object linking from excel to word

[susanc]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Copy a cell from excel into word as special paste object link, when I print, it prints a cell box around the object.
1. How do I get rid of this box (doesn't do this in 2004)
2. It positions insert before my text, not where I have put the cursor.

 

[susanc]

This is Mac version of word.

 

[CyberTaz]

Unfortunately this is a PITA that has yet to be resolved & I'm not confident
that it will be for the 2008 version. As an alternative use the Paste
Special options for either 'Unformatted' or 'Formatted' Text unless you'd
prefer to have it as a floating object for some reason. If that's the case
use HTML to paste it as a table cell. Either way the Linking is preserved.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[John McGhie]

I don't quite understand your question.

In Word>Preferences>Edit, check that "Insert/Paste pictures" is set to
"Inline with text" if you want them to land where the cursor is.

When pasting from Excel, use Edit>Paste Special... And choose a text format
if you simply want the text, Otherwise, Word will attempt to paste the
selection as a an Excel object or as a Word Table Cell, depending on what
you have selected, hence the border.

Hope this helps

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Copy
a cell from excel into word as special paste object link, when I print, it
prints a cell box around the object.
1. How do I get rid of this box (doesn't do this in 2004)
2. It positions insert before my text, not where I have put the cursor.

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]