I haven't been able to make it work but this thread indicates you can edit the link to point at a named range rather than the cell references
Dynamically link Excel to Word - (paste as link wont fit need) | MrExcel Message Board

Does that method work for you?

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia