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

trjackson77

New Member
Joined
Jul 4, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
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:
1625431242043.png


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.
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Forum statistics

Threads
1,148,257
Messages
5,745,712
Members
423,969
Latest member
seanguerrero

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top