Excel hyperlinked to Word is not coming in at 100%

[Lisa Kerlin]

I have been battling for days trying to get hundreds of tables from excel into word at 100%.



I am creating an annual report which is hundreds of linked excel tables in a word document. I have gone through each table and made the column and row sizes consistent and know that generally my tables measure 177.7cm wide. When I am pasting into word it is coming in at 96% x 107% and says that the actual 100% size is 16.58cm for example.

I am working in 2010 and am finding this extremely frustrating. As the tables will be constantly updated and possibly changed. I need to know that they will come in at 100% when copied. Giving me consistent sized tables, columns and rows throughout.

Any ideas.

[macropod]

To some extent at least, the problem you're experiencing is due to the fact that Excel's aspect ratios are off. For example, if you insert a perfect circle shape into Excel then print it, it typically comes out as an oval. If you insert your Excel links into a one-cell Word Table with a fixed column width, the object will resize itself to fit that, though there's little you can do about the aspect-ratio issue other than resizing the rows & columns in Excel.