Excel Services warning

Question

Hi,

 

 I have asked this question in the TFS forums, but noone is answering, I though you guys might be in a position to help me.

I have recently start to use Excel Services with Sharepoint 2010 and TFS

I have enabled the Agile Dashboards with Excel Reporting. This in turn gave me more dashboards, but on the dashboards that use excel service reports (i.e. Bugs), I am always prompted with a dialog box on every web part:

-----------------------------

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

-----------------------------

I'm not sure what trusted source I need to add to my Excel Service setting, there are some already in there, but obviously not the right ones :(

Thanks again

Graham

Answer 1

You can see sources are used in this workbook through desktop Excel application. What version Excel do you have?

Answer 2

Excel 2010. But this error occures when viewing the web part in IE.

Answer 3

If I understand your question, you are wondering how to disable this warning?

It is an Excel Services trusted file location setting.  In SharePoint Central Administration, manage service applications, and manage the Excel Services application.  Manage the Trusted File Locations, and select the one that applies to your workbook.  There should be a checkbox next to "Refresh warning enabled".  Uncheck that checkbox.

Of course, the security implication here is that workbooks that are configured to successfully refresh using data providers will no longer prompt the user before doing so.

David