Creating an Excel linked table in Word (Not a linked range)

[trjackson77]

I have a table in an excel spreadsheet that I have copied and link-pasted into Word. The link is to a range of cells, not the whole table.

So in Excel, I created a range that referred to the table like so:
rngStudentStarts=StudentStarts[#All]

I then tried to edit the Link using the edit link dialogue box in Word, so that the link referred to the names range rather than the original cell selection:
{LINK Excel.Sheet.12 "https://[...Redacted...].sharepoint.com/sites/ApprenticeshipRecords/Shared%20Documents/Student%20Records%20System%20(SRS)/Employer%20Report%20Backend.xlsx" "rngStudentStarts" \a \f 5 \h \* MERGEFORMAT}

However, I get the following error:

I'm guessing its how I've refferred fo my range or something to do with the switches at the end. But I can't for the life of me find documentation on how to do this.

Essentailly, what I want to do is have the whole dynamic table update in Word on update rather than a static cell selection. The data from the linked table is coming from an external source via Power Query.

Any pointers would be most helpful.

Tim.