Linked Excel Worksheet in Word Does Not Work

[shortenjam]

Hello,

Have a situation and it's driving me nuts.

I have an open worksheet, copy it, go to Word, Paste Special-Paste Link-Microsoft Excel Object-Ok.

All of the tutorials I've seen shows the actual worksheet populate in Word. Not for me. Instead I just get a source path or file path. Please see below.

{ LINK Excel.Sheet.12 "C:\\Users\\james\\Desktop\\New Factory and Site Options Worksheet.xlsx" "Sheet1!R2C1:R9C10" \a \p }

For the life of me I cannot figure this out. Nothing online I've found has helped me.



Appreciate any input.