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]

Sorry about the confusion. What I meant was the Excel file is usually used to generate different client's information, before we churn out the final contract, so each XLS would be different. I think I'm going with the more tedious but safe method to make people export the data before they save a separate Excel for each client.

If I still need the prompt for loading x number of rows in my table, would this lock and ref method still work or do I have to write a complex VBA for it? Referring to my earlier post here. https://www.msofficeforums.com/word-...ng-prompt.html