Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
90
Views
Topic starter
I am having trouble figuring out why I cant choose Close & Load To Connection Only in a workbook that has multiple Queries. The workbook uses separate queries that reference one "master" query to extract grades for individual school districts from a master that contains all schools. I would like to save these queries as connections only as opposed to new worksheets, but the link to do this is ghosted out, so I can't do it. What am I missing?
Posted : 13/12/2016 1:21 pm
Hi Cheryl,
Try to do that from sheet, not from Query window. Show Queries Panel, then right click the query and choose Load To to open the Load settings.
Posted : 14/12/2016 12:58 am