•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Formulas break when power query table refreshes
I have a power query that loads to a table. I have xlookup formulas that reference ranges in the table. When I refresh the query, one column is replaced by another and that breaks the formulas. I can't use index/match because the formulas reference rows and that will just pick up the first instance.
Month column gets refreshed and formula turns into #ref errors. Not sure how much more clearer I can make.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#AI formula generation techniques
#Excel compatibility
#Excel alternatives for data analysis
#formula generator
#Excel alternatives
#power query
#formulas
#table
#xlookup
##ref errors
#refresh
#column
#formula break
#ranges
#excel
#index/match
#load
#month column
#rows