Hi everyone,

I have created a table in Excel through PowerQuery. I expanded the table with additional formula columns that also refer to the query input columns using the table column headers (for example [@[column 1]] ). The issue is that when the query is being refreshed, the referring columns receive a #REF error. A Google search to similar issues recommended to turn on the “overwrite cells with new data” function. However, I did not have luck with this.

Does anyone know that whether my approach is possible or do I have to look for a workaround?

​Hi everyone,I have created a table in Excel through PowerQuery. I expanded the table with additional formula columns that also refer to the query input columns using the table column headers (for example [@[column 1]] ). The issue is that when the query is being refreshed, the referring columns receive a #REF error. A Google search to similar issues recommended to turn on the “overwrite cells with new data” function. However, I did not have luck with this. Does anyone know that whether my approach is possible or do I have to look for a workaround?    Read More

​