Forum Discussion
Refresh PowerQuery table gives #REF
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?
1 Reply
- Does it work if you use regular cell references instead of structured table references?
