Power Query removed Worksheet Connection dialog box?

[Ave663]

Hi All,

I have been using Power Query recently and have noticed that it has removed the ability to connect to the Worksheet Connection dialog box via the Connections button on the Data Ribbon...

Is there any way of accessing this dialog box window now Power Query is in use or does other functionality now take over this? Sorry I am a little new to the data connectivity side of Excel and am still getting used to it...

Any help would be gratefully accepted...

Thanks
Ian

 

[sandy666]

maybe load the query (or table) you want to the sheet, then delete just loaded query table and you should see connection
or right click on your Query , choose Load to then Only Create Connection

if you don't have any query/table in Queries&Connections pane so how do you want to see any connection?

 

[Ave663]

Hi...

Well i wanted to understand why i am missing access to the Worksheet Connections dialog box to manually create connections to other worksheets and specifc cells... you can see here in this Office article what i was looking for...

Create, edit, and manage connections to external data - Microsoft Support

You can use Microsoft Office Excel to create and edit connections to external data sources that are stored in a workbook or in a connection file. By using the Workbook Connections dialog box, you can easily manage these connections, including creating, editing, and deleting them. Data in an...

support.office.com

since i have been using Power Query this dialog box and window i cant get anymore... i just wanted to know if that is usual and if it is how i can do the same type of simple data links as this once did...

I hope that makes sense?!

 

[sandy666]

The problem exist from the years
IMHO only MS knows why this is happening and they haven't fixed it yet
On the net you can find solution how to restore connection but not how to fix it global
You can smile and live with it

 

[Ave663]

I have MS Support ringing me tomorrow now to discuss this... if there is anything useful i will post back and let you know...

 

[sandy666]

Will be fine to see detailed answer from MS about that