Spleen's fine, thanks, and I do appreciate the assistance, but when using the Paste and Keep Formatting function from Excel to Word, the new table in Word does not maintain the original table format, even when you past a relatively small table.



Sorry, but not that experienced here and I tried the link you mentioned but not sure how to find that solution you mentioned above with the DWORD value thing.

The object resizes because that how it's designed to work; the idea being to preserve the original formatting. The registry edit is for those who want it to work differently.
It's not a link - it's a registry edit.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

This is a work computer so I'm getting our IT guy to make the fix. Hopefully this works. I also discovered I can't use paste "picture" or "bit map" because it won't track changes to the table.

The issue with table formats not carrying over from Excel to Word when using "link with source formatting" seems to be with numbers only. Words in table cells seem to maintain their format in Word, whereas any numbers in cells automatically creates a larger row height in Word (maybe it's wrapping) and the use of dollar signs that are flush left in Excel always wraps into a second line in Word.

OK; got my IT guy to make the registry change and it may have helped somewhat. What I've discovered is still or the real problem with linking tables from Excel to Word using "keep source formatting" is any formatting to the numbers in tables, be it comma for thousands or a $ sign will create some sort of wrapping of the column and increase the height. If you use numbers without any accounting format, it works fine.

Edit: Actually it appears than you can format using "Number" or "Currency" format but any "Accounting" format blows up the table formatting in Word.