Microsoft KB Archive/928744

Knowledge Base

Error message when you try to update Excel 2007 workbook data from an external data source in SharePoint Server 2007: "Data Refresh Failed"

Article ID: 928744

Article Last Modified on 5/14/2007

---

APPLIES TO

• Microsoft Office SharePoint Server 2007

---

SYMPTOMS

Consider the following scenario. You use Microsoft Office Excel Web Access to view a Microsoft Excel 2007 workbook in Microsoft Office SharePoint Server 2007. The workbook contains data from an external data source. And, the workbook uses Microsoft Single Sign-on authentication. In this scenario, when you try to update the data from the external data source, you may receive an error message that resembles the following:

Data Refresh Failed Unable to retrieve external data for the following connections: workbook connection name The data sources may be unreachable, may not be responding, or may have denied you access. Verify that data refresh is enabled for the trusted file location and that the workbook data authentication is correctly set.

CAUSE

This issue occurs if the account that is used for anonymous access in Microsoft Internet Information Services (IIS) is not a valid domain account.

RESOLUTION

To resolve this issue, follow these steps:

1. Click Start, click Run, type inetmgr, and then click OK.
2. Expand the computer that you want, expand Web Sites, and then expand Office Server Web Services.
3. Right-click the application pool that you want, and then click Properties.
4. On the Directory Security tab, click Edit in the Authentication and access control area.
5. Click to select the Enable anonymous access check box.
6. In the User name box, type a valid domain account.
7. In the Password box, type the password for the account that you entered in step 6.
8. Click OK two times.

Keywords: kbexpertiseinter kbquery kbtshoot kberrmsg kbprb KB928744

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.