If you are still getting the "locked" error, see Excel file is locked for modifying For additional methods to this issue.It's also possible to enter or alter structured references manually within the method but to do this, it will help to grasp structured reference syntax. Permit’s go more than the next formula instance:To add a industry to the n