Thread: [Solved] Linking from Excel - Help auto-resizing tables
View Single Post
 
Old 02-16-2020, 06:47 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Give your Excel range a name, then edit the LINK field's address to point to that name. You can toggle the field code display on/off by pressing Alt-F9. 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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote