•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