Pasting Excel comments into Word using Macintosh with Office 2004

[Dillyrock]

Hi, thanks in advance for your help. I'm very impressed by the
knowledge here.

When I paste an excel spreadsheet (or a portion of one) into Word as an
object, I can get the gridlines and row/column headers to appear fine,
but the comment boxes and the text within the comments become skewed in
word and do not appear where they should.

In Excel, I go to File--> page setup --> Sheet---> Comments - "As
displayed on sheet". I paste the spreadsheet (or a portion of it),
including the comments, into word as a picture, and the comments become
skewed and unreadable. I paste by going to Edit---> Paste Special --->
"As Picture". The boxes have moved in the word doc (covering up other
text that is important to see), and the text is not in the boxes. I
assume the comment text and boxes are somehow pasted into word as
different layers, because they're all messed up unlike the gridlines
and row/column headers.

This problem only seems to exist on a Macintosh. (I'm using a new
Powerbook G4 15"). PC users have no problems. One thing that seems to
work OK for me is to save the excel file as a pdf. Then I have to crop
the pdf closely around the picture (otherwise the pasted image/object
will be 8.5" by 11"). Then, in Word, I go to Insert---> Picture --->

From File, choose the pdf, and it works OK.

But I have exams where I have to paste lots of things into word under
time pressure, and this would take too much time. Any thoughts on how
to get the simple paste working? Thanks again.

 

[John McGhie [MVP - Word and Word Macintosh]]

Hi Whatever your name is:

I am afraid this is a bit of a bridge too far in Mac Excel/Mac Word.

Paste>Special... "As Picture" usually works for me, but there's no
guarantee. Pasting as RTF may also work.

But the method you are using, Save to PDF, is the one I would also use for
tough cases. Failing that, you could paste into PowerPoint, export from
there as PICT or PNG and put that in your Word document.

It's still a fiddle, and I would back the PDF results against PICT or PNG
every time

Cheers

Hi, thanks in advance for your help. I'm very impressed by the
knowledge here.

When I paste an excel spreadsheet (or a portion of one) into Word as an
object, I can get the gridlines and row/column headers to appear fine,
but the comment boxes and the text within the comments become skewed in
word and do not appear where they should.

In Excel, I go to File--> page setup --> Sheet---> Comments - "As
displayed on sheet". I paste the spreadsheet (or a portion of it),
including the comments, into word as a picture, and the comments become
skewed and unreadable. I paste by going to Edit---> Paste Special --->
"As Picture". The boxes have moved in the word doc (covering up other
text that is important to see), and the text is not in the boxes. I
assume the comment text and boxes are somehow pasted into word as
different layers, because they're all messed up unlike the gridlines
and row/column headers.

This problem only seems to exist on a Macintosh. (I'm using a new
Powerbook G4 15"). PC users have no problems. One thing that seems to
work OK for me is to save the excel file as a pdf. Then I have to crop
the pdf closely around the picture (otherwise the pasted image/object
will be 8.5" by 11"). Then, in Word, I go to Insert---> Picture --->

But I have exams where I have to paste lots of things into word under
time pressure, and this would take too much time. Any thoughts on how
to get the simple paste working? Thanks again.

--

Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.

John McGhie <[email protected]>
Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer
Sydney, Australia +61 (0) 4 1209 1410

 

[CyberTaz]

Hello-

Just another thought - Have you tried Edit>Paste Special>MS Excel Worksheet
Object? (Or Insert>Object>From File.)

When you Paste/Insert As Picture I believe the text (vectors) gets
rasterized, so the Comments in particular (since the font size is rather
small) will understandably become 'jaggy'.

HTH |:>)

 

[PhilD]

Just another thought - Have you tried Edit>Paste Special>MS Excel Worksheet
Object? (Or Insert>Object>From File.)

Another posibility which may be acceptable in certain circumstances is
the ultra low-tech option of keeping Word, Excel and everything else
separate. Refer in the text in Word to Table 1, Appendix A or
whatever, and call your spreadsheet Table 1, Appendix A or whatever.
It's my preferred way of dealing with things and saves the hassle of
"cross contamination" between applications.

PhilD

 

[Dillyrock]

Thanks John. (My name is Brandon by the way.) Unfortunately Powerpoint
shows the same skewed text and text boxes as Word does. RTF didn't work
either. Looks like PDF is my only option.
Thanks. -brandon

 

[Dillyrock]

Hi -
None of the other options work either. I've tried pasting as an Excel
Worksheet (and every other paste or insert option). Keeping them
separate wouldn't work for my purposes, as I have to display a chart
and explain it. But thanks for the suggestions, I guess I will stick to
PDF or use Virtual PC.

-brandon

 

[John McGhie [MVP - Word and Word Macintosh]]

Hi Brandon:

Yeah, that figures. It's a very complex problem to solve. The applications
don't layout their pages the same way, or necessarily use the same fonts.

PDF is a good way out

Cheers

Thanks John. (My name is Brandon by the way.) Unfortunately Powerpoint
shows the same skewed text and text boxes as Word does. RTF didn't work
either. Looks like PDF is my only option.
Thanks. -brandon

--

Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.

John McGhie <[email protected]>
Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer
Sydney, Australia +61 (0) 4 1209 1410