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.

You receive an error message when you use Excel Web Access to refresh the data connections for an Excel 2007 workbook


View products that this article applies to.

Symptoms

You use Excel Web Access to view a Microsoft Office Excel 2007 workbook. When you refresh the data connections for the workbook, you receive the following error message:
Data Refresh Failed
Unable to retrieve external data for the following connections:
<data 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.

↑ Back to the top


Cause

This behavior occurs if the following conditions are true:
  • The Excel Services Authentication settings for the workbook are set to either Single sign-on (SSO) or None.
  • You use Microsoft SQL Server 2005 to restore the SharePoint Server 2007 Shared Service Provider (SSP) and Search databases.
    Note This regenerates the encryption key for the Unattended Service Account credentials.

↑ Back to the top


Workaround

To work around this behavior, reenter the Unattended Service Account information after you restore the SSP and Search databases. To do this, follow these steps:
  1. Visit http://host_name:port_number/ssp/admin/default.aspx.

    Note In this URL, host_name:port_number is the name and port of the Shared Service Provider Web server in the SharePoint Server 2007 deployment.
  2. In the Excel Services Settings section, click Edit Excel Services Settings.
  3. In the External Data section, type a valid account name in the Name box, type the password for the account in the Password box, and then retype the password in the Retype Password box.
  4. Click OK.

↑ Back to the top


Status

This behavior is by design.

↑ Back to the top


More information

For more information about data connections for Excel Services, visit the following Microsoft Web site:

↑ Back to the top


Keywords: KB928728, kbprb, kbtshoot, kberrmsg, kbpermissions, kbexpertiseinter, kbexpertisebeginner

↑ Back to the top

Article Info
Article ID : 928728
Revision : 5
Created on : 5/14/2007
Published on : 5/14/2007
Exists online : False
Views : 298