I am trying to paste an Excel table into Word as a linked object so that the Word document will automatically update when changes are made to the spreadsheet. I am following these steps:
1. Copy the table
2. In Word, click the arrow under Paste (on the Home ribbon)
3. Click "Paste Special"
4. Select Paste Link; highlight Microsoft Excel Worksheet Object (the top option in 'Paste Link'), and click OK
It goes into Word okay, but the formatting is slightly off: a couple of the borders that I have set at the thinnest setting for a solid line are showing in Word as heavier lines. Why is it doing this and how can I make it paste with the exact format that is in Excel? I am using the 2010 version.