Query & Connection

D

dallen8028

New Member
Joined
Jan 28, 2013
Messages
48
I have lost the connection from a query I have been using for over a year. The website with the data still exists as I have just visited it before posting this. I created the link with 2016 and now I am using 2019/20. The process appears to have changed as I can no longer make the connection. The have not been able to find a way to reconnect. Will someone help me? Thank you in advance.
 

Attachments

  • Query Error.jpg
    Query Error.jpg
    37.1 KB · Views: 7
  • Security Warning.jpg
    Security Warning.jpg
    13.2 KB · Views: 7

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Sort by date Sort by votes
dallen8028 said:
I have lost the connection from a query I have been using for over a year. The website with the data still exists as I have just visited it before posting this. I created the link with 2016 and now I am using 2019/20. The process appears to have changed as I can no longer make the connection. The have not been able to find a way to reconnect. Will someone help me? Thank you in advance.
Click to expand...
Another Error Message
 

Attachments

  • Unable to Connect.jpg
    Unable to Connect.jpg
    17.3 KB · Views: 6
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
Power Query Settings - Faster Refresh/Load after Swapping Computers
Replies
1
Views
151
johnny51981
J
M
  • Question Question
Database Username / Pass for Power Query Connection not saving in Excel workbook
Replies
1
Views
923
ExcelToDAX
E
C
  • Question Question
Query source folder contains too much info, the query breaks before it can load. What are my options?
Replies
4
Views
518
Matt Allington
M
T
  • Question Question
Power Query - Help combining workbooks with some shared column names but also different columns names
Replies
3
Views
204
johnny51981
J
R
  • Question Question
Parameter to pass folder (static) and file name (dynamic) to a query as a source file
Replies
2
Views
1K
rgs694
R

Forum statistics

Threads
1,223,783
Messages
6,174,524
Members
452,569
Latest member
Ron1970

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top