Web Query gives secure/insecure prompt

Mezmer

New Member
Joined
Dec 27, 2004
Messages
41
Hi,

I've been using a web query on a site for awhile, with no issues. I use the query to go to a site and grab a table which is placed in an Excel worksheet and filtered for content.

Today when I went on the site through the query, it gives me a prompt "this site contains secure and insecure information, do you want to display the insecure information".

It had no such prompt in the past, the site has not changed to my knowledge.

The result is that I can not get the query to work any longer, I say yes to the prompt, to allow the insecure info but now when I click import- Excel returns with an error "unable to open https//:www.(my site here).com . Cannot download the information you requested." :oops:

Is this new? Is there a work around?

Thanks in advance for any assistance here. Much, much appreciate any and all help.

M
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Forum statistics

Threads
1,147,668
Messages
5,742,514
Members
423,734
Latest member
123hmMission

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
Top