I am trying to link automatically updating Excel tables to a Word document, and since the file will be used by different people, it should also work across different computers.
I am using the Paste Link function for this, and although it works perfectly as long as I keep the files in the same folder, whenever the file is opened on a different computer and the Excel file location has to be linked again, it forgets the table range and churns out the entire Excel worksheet instead. This seems to be the case for all paste options: RTF, worksheet object, unformatted unicode text, etc. On the other hand, graphs do not have this issue.
Is there a possibility to have the table or its range automatically update without having to manually input the range for every table I use? Any suggestions would be greatly appreciated!