Thread: [Solved] Linking from Excel - Help auto-resizing tables
View Single Post
 
Old 02-19-2020, 10:07 PM
Cantora Cantora is offline Windows 10 Office 2019
Novice
  
Join Date: Jan 2020
Posts: 6
Cantora is on a distinguished road
Default
Quote:
Originally Posted by macropod View Post
Give your Excel range a name, then edit the LINK field's address to point to that name. For example:
{LINK Excel.Sheet.8 "C:\\Users\\UserName\\Documents\\Workbook.xls" "Sheet1!R1C1:R10C6"}
becomes:
{LINK Excel.Sheet.8 "C:\\Users\\UserName\\Documents\\Workbook.xls" "Sheet1!Table"}
Now, whenever the range spanned by the name changes in Excel, the link in Word will update to reflect the change.
Hi Macro,

Thanks so much for this. It wasn't a working solution unfortunately, but it did lead me to search for new terms which found me the right solution.

For tables: you need to define a name & for pivots you need to define an indirect name to an expanding formula (e.g ="A2"&COUNTA(D))

thanks so much for your help with this
Reply With Quote