Can't use Google sign-in for web query in Office365

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:

  1. In Internet Explorer,  open Internet Options. 

  2. On the Security tab, add *.google.com as a trusted site.

  3. Check that Protected Mode (default) is not enabled for trusted sites.

  4. Close Excel.

  5. 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.

  1. Reopen Internet Explorer

  2. Paste in the web query URL and sign in.

  3. Wait until the web query results load.

  4. In Excel, try the web query.

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

Search
Clear search
Close search
Google apps
Main menu
17724468445468019142
true
Search Help Center
true
true
true
true
true
5055977
false
false