Thread: Exporting Selected Data from Excel to Locked Word File
View Single Post
 
Old 01-13-2021, 09:12 PM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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
It's not clear whether you mean 'edit' the Excel file or reference a different one. Either should be possible.

If editing is liable to result in a change in cell addresses, it'd be best to name each cell and refer to the range name in the Word link. That way, the link will follow wherever the range name in Excel points to.

To use a different Excel file, you'd need to use Word's Edit Links function, which isn't normally visible. You can add its button to the QAT, or access it via File|Info.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote