Forum

Close and load to c...
 
Notifications
Clear all

Close and load to connection

2 Posts
2 Users
0 Reactions
90 Views
(@culsh)
Posts: 43
Trusted Member
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
(@catalinb)
Posts: 1937
Member Admin
 

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
Share: