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.