Hi, I have a table in a Word template that I have linked to an Excel spreadsheet, by copying each cell in Excel and pasting into the corresponding cell in the Word template using the 'paste special, paste link, unformatted text' option from the Paste button on the ribbon.

Maybe I could have linked the two documents better in the first place, but what I am looking for now is a macro to assign to a keyboard shortcut. I've found heaps of macros that manage the paste unformatted text bit, but not the link bit. I'm a macro newbie, so I can't figure out how to modify an existing one, to retain that link.

All advice gratefully received!

Thanks, Ruth