Renaming columns in data source causing #REF! error in formulas with structured reference

[PanBrodacz]

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 structured reference in output file.

3. PowerQuery not include any column names.

Is there any way to avoid breaking that structured reference in formula?

[PanBrodacz]

Thank you for your answers but I prefer version with column name. Is there any solution in that way?

[KT_Bsmart2gethe]

Hi @PanBrodacz ,

Here is a bit old fashion method:

1. Cell E1, reference to Cell A1;
2. Cell E2 add formula: Indirect("List1["&E1&"]")

Regards

KT

[AKNiang]

You can avoid referencing the column name in the formula.

Reference instead the column A.

=List1(A:A)