If you use Office 365 and cannot get Web Query to authenticate, there may be an issue with the Office embedded browser. To address this Issue, you need to update your Internet Explorer security settings, and then sign in again to Internet Explorer.
First, check your Internet Explorer security settings:
-
In Internet Explorer, open Internet Options.
-
On the Security tab, add
*.google.com
as a trusted site. -
Check that Protected Mode (default) is not enabled for trusted sites.
-
Close Excel.
-
Close Internet Explorer.
Next, sign in to Internet Explorer so that Excel's built-in browser can use the authentication you just set up in Internet Explorer.
-
Reopen Internet Explorer
-
Paste in the web query URL and sign in.
-
Wait until the web query results load.
-
In Excel, try the web query.