Forum Discussion
Renaming columns in data source causing #REF! error in formulas with structured reference
1. I have a table with data from other file and formulas with structured reference to that table. 2. When I rename column in file with data source it causing #REF! error in formula with str...
You can avoid referencing the column name in the formula.
Reference instead the column A.
=List1(A:A)