understanding linked excel table in Word 2010

User avatar
capri
StarLounger
Posts: 87
Joined: 20 Jan 2011, 06:42

understanding linked excel table in Word 2010

Post by capri »

Hi,

I've always preferred to paste Excel tables into Word documents as metafiles, but my new manager insists on linked tables. As I've been going through reports linking tables I've run into numerous problems with the column widths. eg the width in Word is too wide, but if I narrow the width in Excel then the Word appears okay (in excel text does not all fit but in Word it does). I tried changing 3 value columns to a width of 10 but the third column was much wider until I manually adjusted just that column.

Can anyone explain what is happening when you link, and how can you get a reasonable appearance in Word without distorting the the appearance in Excel? It's almost as if Word is allow "X" width for the table and depending on how I adjust the column widths, it will force one out of proportion to follow whatever table width it has allowed for.

Thanks
capri

User avatar
HansV
Administrator
Posts: 78788
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: understanding linked excel table in Word 2010

Post by HansV »

When you select Paste > Paste Special... in Word, which of the available formats do you select?
x998.png
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

User avatar
capri
StarLounger
Posts: 87
Joined: 20 Jan 2011, 06:42

Re: understanding linked excel table in Word 2010

Post by capri »

Hi Hans,

I've been using Paste Special then selecting the icon for Link and keep Source Formatting. I'll give it another try using the HTML format. Thanks

capri

User avatar
macropod
4StarLounger
Posts: 508
Joined: 17 Dec 2010, 03:14

Re: understanding linked excel table in Word 2010

Post by macropod »

If you paste an Excel worksheet object into word (whether as a link or otherwise), simply dragging the sizing handles from any corner will allow you to re-scale everything in the object. You can also re-scale the width and height independently of each other.
Paul Edstein
[Fmr MS MVP - Word]

User avatar
capri
StarLounger
Posts: 87
Joined: 20 Jan 2011, 06:42

Re: understanding linked excel table in Word 2010

Post by capri »

Thanks macropod,

I knew about that, however my problem was when pasted the first column took up almost the entire width of the portrait Word document so the other columns ran well of the page. I could not grab the right hand corners to resize. I found that playing around with the width of the columns in Excel could adjust the size, but it was tedious doing that with every object. Hans solution of using the HTML format worked much better.

capri

User avatar
macropod
4StarLounger
Posts: 508
Joined: 17 Dec 2010, 03:14

Re: understanding linked excel table in Word 2010

Post by macropod »

As I said:
simply dragging the sizing handles from any corner will allow you to re-scale everything in the object
So, even if you can't see the right-hand side of the object, you can use the handles in the left top or left bottom corners for the rescaling.
Paul Edstein
[Fmr MS MVP - Word]