Technology Toolbox

Your technology Sherpa for the Microsoft platform

Jeremy Jameson - Founder and Principal

Search

Search

Avoid the Warning from Excel Services About Refreshing External Data

Note
This post originally appeared on my MSDN blog:

Since I no longer work for Microsoft, I have copied it here in case that blog ever goes away.

In my post earlier this month on upgrading to Team Foundation Server (TFS) 2010 and SharePoint Server 2010, I forgot to include the steps to change the Warn on Refresh setting of the trusted file location for the Excel Services Application.

If you leave this value set to the default (i.e. Yes), then you'll be greeted with the following message for each Excel Web Part on a TFS dashboard page:

This workbook contains one or more queries that refresh external data. A malicious user can design a query to access confidential information and distribute it to other users or perform other harmful actions.

If you trust the source of this workbook, click Yes to enable queries to external data in this workbook. If you are not sure, click No so that changes are not applied to your workbook.

Do you want to enable queries to external data in this workbook?

To avoid warnings before refreshing external data in Excel Services:

  1. On the SharePoint Central Administration home page, in the Application Management section, click Manage service applications.
  2. On the Service Applications page, click Excel Services Application.
  3. On the Manage Excel Services Application page, click Trusted File Locations.
  4. On the Excel Services Application Trusted File Locations page, point to the trusted file location that you want to edit (e.g. http://), click the arrow that appears, and then click Edit.
  5. On the Excel Services Application Edit Trusted File Location page, in the External Data section, clear the Refresh warning enabled checkbox, and then click OK.

Note that if you are using Microsoft Office SharePoint Server (MOSS) 2007, the configuration steps will be slightly different (the setting is changed through the SSP admin page). Refer to the following for more information:

Manage Excel Services trusted file locations

Comments

  1. # re: Avoid the Warning from Excel Services About Refreshing External Data

    June 24, 2010 3:18 AM
    Paul

    Thanks for taking the time to post this!  That nicely fixed my default portal for new TFS projects.

  2. # re: Avoid the Warning from Excel Services About Refreshing External Data

    July 27, 2010 7:36 AM
    KP

    I have configured trusted location as explained above but still I am getting same error.  Do Excel file itself need any configuration?

  3. # re: Avoid the Warning from Excel Services About Refreshing External Data

    July 28, 2010 9:04 PM
    Jeremy Jameson
    Gravatar

    @KP:

    No, I didn't have to configure the Excel file itself.

Add Comment

Optional, but recommended (especially if you have a Gravatar). Note that your email address will not appear with your comment.
If URL is specified, it will be included as a link with your name.

To prevent spam from being submitted, please select the following fruit: Watermelon

Grapes
Watermelon
Strawberry
Pear
Apple
Cherries
 
Please add 8 and 8 and type the answer here: