Kwizcom Forms

This workbook contains one or more queries that refreshing the external data SharePoint 2010 warning

This SharePoint tutorial, we will discuss how to solve 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 warning message which comes in SharePoint.

Sometime in SharePoint you will get excel work book gave warning message like below:

SharePoint deveopment training course

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?

Reason:
The reason behind this is Excel Services is configured to warn on data refresh.

This workbook contains one or more queries that refreshing the external data

Open SharePoint 2010 central administration, then go to Application Management

Then click on Manage service applications.

Then from the list of service applications, select Excel Service.

Then Click on Trusted File Location in Excel services application page.

Next Select http:// link Excel Services Application Trusted File Location.

In the Excel Services Application Edit Trusted File Location page, clear “Warn on data refresh” checkbox in External Data section and click on Ok.

You may like following SharePoint tutorials:

Hope this SharePoint tutorial helps to resolve his workbook contains one or more queries that refresh external data which comes in SharePoint.

Check out Best Alternative to InfoPath -> Try Now

free sharepoint training

SharePoint Online FREE Training

JOIN a FREE SharePoint Video Course (3 Part Video Series)

envelope
envelope

About Bijay Kumar

I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site SharePointSky.com

View all posts by Bijay Kumar →