Data Connections in Excel 2016 (Only want to create the connection not load the data)

[CharlesBanks]

I am having an issue creating data connections in Excel 2016 (365 subscription) to a MS SQL View. When I attempt to create the connection it asks to load data. I've looked through the DATA >>GETDATA>>FROM DATABASE>>FROM SQL SERVER DATABASE in the advanced options area but couldn't find anything there. Also looked in the properties, etc of the query editor area but can't find it there either.
I only want to create the connection as the data resides in a SQL environment (view). In Excel 2013 there used to be an option to "only create connection". I haven't been able to successfully create data connections since the update and online searches have been futile.

Thanks in advance,
Charles

 

[Paul Ked]

[FONT=&quot]Go to File > Options > Data > Show legacy data import wizards, and select the legacy wizards you want to use:[/FONT]
[FONT=&quot]

Options > Data." title="Image of the Get & Transform Legacy Wizard options from File > Options > Data." ms.cmpgrp="content" ms.pgarea="Body" ms.interactiontype="500" style="box-sizing: border-box; border: none; max-width: 100%;">

Restart Excel

Do an import for the type of connection you want then delete the data.

Select Queries and connections from the Data ribbon and you will see the connection there.[/FONT]

 

[CharlesBanks]

Thank you so much for such a rapid response. I was afraid I was going to have to revert back to an older version.

 

[Paul Ked]

You're welcome