P
p_wills
When you create a list in Excel and publish it, Excel adds an ID column as
the first column. Not only does this mess up every vlookup in the rest of
the workbook (but this is not a bug, rather a design weakness), but more
seriously it fails to update the range names i.e. the range names have not
shifted to the right.
the first column. Not only does this mess up every vlookup in the rest of
the workbook (but this is not a bug, rather a design weakness), but more
seriously it fails to update the range names i.e. the range names have not
shifted to the right.