Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error message when you update a data query on your Excel worksheet: "This Web query returned no data"

Error message when you update a data query on your Excel worksheet: "This Web query returned no data"

Symptoms

When you try to refresh a data query on your Microsoft Excel worksheet, you may receive the following error message:
This Web query returned no data. To modify the query, click OK, click the name of the external data range in the name box on the formula bar, and then click Edit Query on the External Data toolbar.
You are not given the opportunity to submit your password and access the data table so that you can refresh the query.

↑ Back to the top

Cause

This behavior occurs when the data table that you are accessing is password protected. Excel has no way of submitting passwords to external data sources because there is no universal standard for passwords.

↑ Back to the top

Workaround

When you click OK in response to the error message, some Web sites automatically redirect you to the logon screen where you can enter your password. There is no way to work around this issue if the Web site does not redirect you to the logon screen.

↑ Back to the top

Keywords: kbfreshness2006, kboffice12yes, kbweb, kbpermissions, kbpasswords, kbquery, kberrmsg, kbexcel10ready, kbpending, kbprb, ocsentirenet, kb, kbsweptsoltax

↑ Back to the top

Article Info
Article ID : 277596
Revision : 10
Created on : 8/20/2020
Published on : 8/21/2020
Exists online : False
Views : 118