•1 min read•from 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?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#intelligent data visualization
#rows.com
#natural language processing for spreadsheets
#Power Query
#helper query
#main query
#data source
#Excel workbook
#advanced editor
#refresh
#data source folder
#merging files
#Excel ribbon
#query source