1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Helper query source not updating in Power Query.

I have two queries in an Excel worbook: a main query and a helper query that was created automatically when merging files from the data source folder.

When I change the data source via the corresponding function on the Excel ribbon and refresh all, the source of the main query updates correctly. However, the source of the helper query remains unchanged, which causes it to break.

is there a way to change the data source also for the helper query without having to update it manually in the advanced editor?

submitted by /u/SoleSurvivor00
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article