Forum Discussion
[Power Query] PQ Variables linked to named ranges aren't refreshing with Refresh All
Hi all, I'm using Power Query to pull data from other Excel files. As the name of these files change every day, I've worked around this by using using a cell (named range) and pulling it into Pow...
1) _xlpq was introduced for Python in Excel. Even if Python is not available, _xlpq exists in background. That's known issue, recommendation is to use for queries another name, as you did. However, hope will be fixed one day.
2) Try in queries properties to disable Background Refresh. Have no experience with names, but that works with Power Query/ PivotTable when the latest in background refreshes first not waiting while queries will be refreshed. If we have power queries only background refresh changes their order of refreshing, they do not wait one another.