Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
72
Views
Topic starter
I am trying to load a merged query into a worksheet. The "Load & Close to " is not available. Any idea why or am I just missing a trick.
Posted : 14/04/2023 5:13 am
Hi Keith,
If you've already loaded the query, then you don't have the option to change the 'to' from the query editor. However, if you open the Queries & Connections pane in the worksheet and right-click the query, you can change the Load To location, as explained in lesson 5.03.
Mynda
Posted : 14/04/2023 6:53 pm
Topic starter
Thanks Mynda
I had this concept in my head that each query is an individual building block, rather an a cointuuum. Thats the problem when you have not tutch the subject for a year. Hopefully I can get up to speed in the next month.
Thanks again
Keith
Posted : 15/04/2023 1:33 pm