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