I've a SharePoint farm with Excel Application Services configured. I've created a Excel workbook with OData connection to SharePoint list. In Excel web view, I can't refresh data.
Need help !
1 Answer
You may need to make use of the Secure Store Service in order to do that.
Make sure the "Excel" Target Application in the Secure Store Services Application has all the desired members including yourself in the Members list.
Also, make sure the Authentication Settings is set to None or the SSS, not the authenticated account. This is under the Excel workbook -> Data -> Connections -> Properties of the DataConnection -> Definition -> Authentication Settings
-
Done it ! The error is about another data connection : a datamodel called ThisWorkbookDataModelBlue Geek– Blue Geek2015-09-10 14:23:11 +00:00Commented Sep 10, 2015 at 14:23
-
Excel can't refresh this datamodel.Blue Geek– Blue Geek2015-09-10 17:47:22 +00:00Commented Sep 10, 2015 at 17:47
-
Make sure the credential using the Excel Unattended account has access to view the web application fully, and also make sure the "Members" of the SSS target application that uses the excel unattended account includes all users.Mike– Mike2015-09-10 21:37:31 +00:00Commented Sep 10, 2015 at 21:37
-
Done it ! same error !Blue Geek– Blue Geek2015-09-11 18:12:18 +00:00Commented Sep 11, 2015 at 18:12
-
I have done the same thing but I'm still having the same issue.. can someone please help me? I have configured unattended account and set the connection string to none but I still get an error occurred in the data model.Khalifa Sabt– Khalifa Sabt2016-01-11 13:45:19 +00:00Commented Jan 11, 2016 at 13:45