I am having difficulty linking Excel data from a simple worksheet table to a table in Word 2007. I would like to retain all the formatting currently used in the Word table, but can't get the Paste Options working at all despite following all the advice on the Microsoft Knowledge Base.
If I copy the Excel data and then place my cursor at the first cell location within the Word table where I want the information to be pasted I get different paste options compared to placing my cursor outside of the table.
I am using the "Medium Grid 3 - Accent 3" Table Style in Word. I find this table style more presentable for my reports than what Excel offers.
I have attached a couple of simple files to demonstrate the formatting and content in both apps.
Step by step help would be appreciated.