Forum Discussion

PanBrodacz's avatar
PanBrodacz
New Member
3 years ago

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

 

3. PowerQuery not include any column names.

 

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

Need Help

3 Replies

  • AKNiang's avatar
    AKNiang
    Frequent Visitor
    3 years ago

    You can avoid referencing the column name in the formula.

     

    Reference instead the column A.

     

    =List1(A:A)

  • KT_Bsmart2gethe's avatar
    KT_Bsmart2gethe
    Impactful Individual
    3 years ago

    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

  • PanBrodacz's avatar
    PanBrodacz
    New Member
    3 years ago

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