How do you turn automatic refresh warning off in the Excel Web Parts with an embedded external data source?
I have created a SharePoint site where I have couple of Excel Pivot tables loaded in the Excel Web Services web parts. The Excel books get their data from SQL Server Analysis Services using a connection data file (odc) and a Single Sign account from SharePoint.
Everything is fine. I can see the data and interact with the Excel web parts. But every time the page loads inside each Excel Web part, I get a warning message and I have to click OK for it to go away. The message is bellow:
“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? “
Is there a way to turn this off for all users? The Excel book has to refresh its data everyday at least.
Any help is appreciated.
Thanks,
I have created a SharePoint site where I have couple of Excel Pivot tables loaded in the Excel Web Services web parts. The Excel books get their data from SQL Server Analysis Services using a connection data file (odc) and a Single Sign account from SharePoint.
Everything is fine. I can see the data and interact with the Excel web parts. But every time the page loads inside each Excel Web part, I get a warning message and I have to click OK for it to go away. The message is bellow:
“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? “
Is there a way to turn this off for all users? The Excel book has to refresh its data everyday at least.
Any help is appreciated.
Thanks,