Excel Services – Query Warning


 You may receive the following warning dialog box when opening a workbook using Excel Services in SharePoint:



Be careful. This workbook contains one or more queries that might be unsafe. Do you want to enable these queries?


To suppress this and other warnings from Excel Services, go to SharePoint Central Administration > Application Management > Service Applications > Manage service applications > Excel Services application > Trusted File Locations and click on the Address that contains the workbook.



In the External Data section, under Warn on Refresh, uncheck Refresh warning enabled and click OK.



Users who access the workbook will no longer be presented with a warning dialog box.






Comments (5)

  1. Pawel: Unfortunately, the feature to disable the ‘Data Refresh Warning’ is not available yet in SharePoint Online panel. Please refer to the following forum discussion for details:


  2. pawel says:

    Thanks for that, but how to do this in Office365? I’m constantly warned about external data refresh, but can’t turn it off – is there a way?

  3. Phil Cole says:

    I too would like to know how to turn this off in SharePoint Online/Office365.

  4. Speaking of, is there anyway to turn off the "New App" warning for Office Apps the first time they’re run? I’d love to hide it, since we’ve already added our custom app to our internal catalog.

  5. Wayne says:

    Good post worked like a charm

Skip to main content