I know you can use Paste Special: MS Excel Object and that keeps the formatting from Excel, but the tables are stretched in Word and do not appear as they do in Excel. The only other paste link options I found that maintain the semblance of my Excel table, is a) Link and Keep Source Formatting, and b) Link and Use Destination Styles. The first one wraps dollar signs that are flush left in Excel and when you format it in Word, the table goes back to the original pasted format whenever you update links. I would think that "b" might keep whatever formatting of the table that I have done in Word, but that doesn't seem to hold up either whenever I update links.

So are you saying that with either of these options I cannot maintain any formatting changes I have made in Word whenever I update links?