View Single Post
 
Old 02-16-2020, 02:55 PM
Cantora Cantora is offline Windows 10 Office 2019
Novice
 
Join Date: Jan 2020
Posts: 6
Cantora is on a distinguished road
Default Linking from Excel - Help auto-resizing tables

Hi All,

I have a word document that links to excel for all it's tables & graphs.
Graphs are easy, but the link for tables seems completely static: If I add a new line in excel I have to change the word formula with the extra lines.

Does anyone know how to make the links resize automatically? Is there a way to link to the Table or Pivot graph rather than a set range?
Reply With Quote