I have vlookup formula in a table which I have changed the table array details for to a new array. The table array was changed following an upgrade of our intranet where the original information came from.
I have amended the formula as it is in about 100 work books using a macro which opens the workbooks and then does a simple replace. This has worked OK and updated the details as required. However if a new line is inserted in the table it keeps the old table array details in the lookup. Is there a way of forcing the table to use the new array details rather than the old ones when lines are inserted.
By the way the lines are inserted using a macro as the workbooks and sheets are protected, I know I could add replace into the macro which would solve the issue but didn't really want to go down this route.
StewartS
I have amended the formula as it is in about 100 work books using a macro which opens the workbooks and then does a simple replace. This has worked OK and updated the details as required. However if a new line is inserted in the table it keeps the old table array details in the lookup. Is there a way of forcing the table to use the new array details rather than the old ones when lines are inserted.
By the way the lines are inserted using a macro as the workbooks and sheets are protected, I know I could add replace into the macro which would solve the issue but didn't really want to go down this route.
StewartS