"Link & Keep Source Formatting" appears as field code syntax, instead of the actual table I want to paste from Excel to Word

Question

Hello everyone,

Really grateful if you can help.  I am trying to link an Excel spreadsheet to a Word document.  When I use the 'link and keep source formatting' method to paste my tables from Excel to Word, the pasted data appears as a raw field code in the Word document eg:

{ LINK Excel.Sheet.12 "C:\Users\xxxx\Dropbox (xxxx)\xxxxr\xxxx\REPORT_TEMPLATE 2018-07-23.xlsx" "xxxx-xxxx!R94C15:R95C47" \a \f 4 \h }

...instead of the table I want to see.  It is necessary to press Shift+F9 to get the table to appear.  When I close the document and re-open it, the field code syntax appears again in place of the table.

Any idea what could be wrong please and how I can fix it?  I do not feel it should work this way...

Graeme

Answer 1

Think it is sorted - had pressed 'alt+F9' due to unfamiliarity with keyboard shortcut, which latched the setting on.

Answer 2

Hi Graeme,

Thanks for your feedback and glad to hear you have figured it out yourself.

Regards,

Yoga