Printing Excel Lists in Word

[yvin73]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

When I copy a List from Excel and Paste Special/ Paste Link/ Microsoft Excel Sheet Object into Word the resulting graphic includes the list visuals. Is there any way to have it not include these visuals when copying the work sheet short of turning off the visuals every time I want to copy a List? In Excel 2004 you could click off of the List and the visuals would disappear, you could then click and drag on the list and copy it without causing the visuals to appear and get a clean selection to paste into Word. Is there any way to do this in 2008? It really doesn't make sense to have to edit the behavior of every single List I want to do this with (I copy and paste Lists a ton). Is there some master setting I am missing?

Thanks!

 

[yvin73]

I am using Office 12.1.1, FYI.

 

[John McGhie]

I'll struggle a bit here because my comprehension ceases at the first
number, so Excel is not my forte...

However, I think the issue is that you are "Linking". When you do that, you
are effectively having a piece of Excel appear in the Word document, and it
will arrive with all of the formatting.

If you want to lose the formatting, then you need to Paste>Special>Word
Table. But if you do that, then you cannot link...

Maybe we should wait for someone who knows this better than I...

Cheers

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

When I copy a List from Excel and Paste Special/ Paste Link/ Microsoft Excel
Sheet Object into Word the resulting graphic includes the list visuals. Is
there any way to have it not include these visuals when copying the work sheet
short of turning off the visuals every time I want to copy a List? In Excel
2004 you could click off of the List and the visuals would disappear, you
could then click and drag on the list and copy it without causing the visuals
to appear and get a clean selection to paste into Word. Is there any way to do
this in 2008? It really doesn't make sense to have to edit the behavior of
every single List I want to do this with (I copy and paste Lists a ton). Is
there some master setting I am missing?

Thanks!

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Microsoft MVP, Word and Word:Mac
Sydney, Australia. mailto:[email protected]

 

[CyberTaz]

I'm not sure what it is that you're referring to by "visuals" - the only
difference I'm seeing in 2008 is that the object retains the AutoFilter
buttons which are separate from Visuals.

AFAIK, however - other than turning the AF Off while you copy - the only
option I know of is to Paste Special as Formatted Text (RTF). That gives you
a Word Table which doesn't support the AF so the buttons don't display. An
additional consideration is that the RTF still doesn't display the AF
buttons when the link is updated, but I believe the Excel Sheet Object will
if the AF is active during updates - even if it was avoided originally.

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

 

[yvin73]

Taz,

You are correct, I mean specifically the Autofilters. I thought those were part of List Visuals. I was hoping there was a way to copy these Lists as linked objects like in 2004 that didn't display the AF, but since they are graphics in 2008 when I try to do the same thing, the AF buttons show up in the "thumbnail" that Word is using. Is there a way to "hide" the AF buttons but still be able to use AF in a list if I were to click on the column header? This would "fix" the thumbnail so that Word would not show the AF buttons.

Thanks!

 

[CyberTaz]

I don't see any possibility of what you're suggesting - After all, the
arrows are an integral aspect of the AF that make the feature what it is

One option I can think of other than the RTF suggestion:

On another sheet in the book create a formula link to the list, then copy
*it* to paste as a link in the doc... So if your list is Sheet1!A15:F50 for
example, put a formula in a cell on another sheet: =Sheet1!A15, then copy it
however many columns across & rows down as necessary to match the original
list. Paste the link from that area rather than inking directly to the list.

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

 

[yvin73]

I do appreciate your help an insight. From my perspective it is frustrating to have a feature change so much from one version of office to another. I could do this in Office 2004 and I can't in Office 2008, so we know that it can be programmed to behave in this manner, it just isn't. (and I want to add "yet" to the end of that sentence, but I am not sure I dare). Anyway, thanks for confirming that I am not missing anything obvious that would help me to do things in the way that I used to do them in the previous version of office!