Excel Online Cross Forest KCD Data Refresh Not Supported

Scenario: You configure Office Online Server with SharePoint 2013 or SharePoint 2016 and have configured Kerberos Constrained Delegation to a data warehouse to pull business intelligence data for your users. You have two Active Directory domains in separate forests in a 2-way transitive trust configuration (We will call them DomainA in Forest 1 and DomainB in…

0

Excel Services - Consuming a SharePoint List using the ListData.svc

Here are the steps I performed to Consume a SharePoint List in Excel Services (SharePoint On Premise): I created a list at this location: http://sp/_layouts/15/start.aspx#/Lists/TomTestList/AllItems.aspx   I then called the listdata.svc from via Excel > Data tab > From Other Sources  > From Odata Feed > http://sp/_vti_bin/listdata.svc I selected my List. I then created a simple…

7

Data Refresh using DSN in Excel Services and PowerPivot for SharePoint 2013

Over the last few months, we have seen a few more instances of people using data sources that require a DSN connection to retrieve data for PowerPivot and Excel workbooks. Normally, if you are just using these data connections inside the client, you just refer to the DSN as a data source and all is…

0

Error using Excel Services for SharePoint 2007 to open Excel workbooks created with Excel 2013

Issue   This has been reproduced with Excel 2013 and SharePoint 2007 SP3.   There is an issue with using Excel Services for SharePoint 2007 to open Excel workbooks that were created with Excel 2013.   If you attempt to open an Excel workbook in the browser that was created with Excel 2013 using Excel Services…

3

Excel Web Access web part won’t display an Excel workbook that will display correctly with Excel Services (xlviewer)

  Issue   In some scenarios, an Excel Web Access web part won’t display an Excel workbook that will display correctly with Excel Services (xlviewer). Instead of seeing the published workbook contents in the web part, there is just a placeholder icon where the workbook should be displayed, and there are no errors in the…

0

Excel Services - Workbook background is blacking out.

I have seen several cases where the background\parts of Excel workbooks are turning black: Here is an example in the browser: Here is an example from the PowerPivot Gallery: From my experience the W3WP.exe is growing in size and this causes issues with performance.  Many times this is the result of a corrupt workbook.  I like…

0

Excel Services Data Refresh - Using Secure Store with SQL Credentials.

This case may be a one-off, but I wanted to write about it in the event someone else comes across it in the future. Here is the synopsis.  A user was creating an Excel workbook in the rich client using "Use Windows Authentication": When you do that, the connection string looks like: Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=AdventureWorks2012;Data Source=Data;Use Procedure for…

4

When must I reboot a server running Excel Services?

I have seen the below errors that required a server reboot to fix the issue: Error in GUI: Error in ULS: 03/06/2014 17:43:45.29 w3wp.exe (0x3B38) 0x574C Excel Services Application Excel Calculation Services 89rs Exception ExcelServerApp..ctor: An unhandled exception occurred during boot. Shutting down the server. Microsoft.Office.Excel.Server.CalculationServer.Interop.LoadDllException: Failed to load engine dll.Acceso denegado.       at Microsoft.Office.Excel.Server.CalculationServer.Interop.EngineInterop.LoadDll(EngineFlags engineFlags,…

1

Excel Services 2013 issue with IE 11.0.9600.16438 - UPDATE

There appears to be an issue with SharePoint 2013 Excel Services when using IE 11 (11.0.9600.16438).  As noted in the comments below, the issue is resolved by installing the October 2013 Cumulative Update for SharePoint 2013: Description of the SharePoint Server 2013 cumulative update package (SharePoint server-package): October 26, 2013 http://support.microsoft.com/default.aspx?scid=kb;EN-US;2825647 See this blog for detail…

12