TFS 2017 and Sharepoint 2013 - OLAP pivot table in excel refresheable only when opened in excel (not excel services) RRS feed

  • Question

  • Defined a simple pivot table in microsoft excel file working with the TFS Olap cube. When opened and refreshed from microsoft excel directly it works nicely, but when opened from sharepoint 2013 as document in some documents library in sharepoint, get the following error, also when trying to refresh afterwards from the document as displayed in excel services in sharepoint. Any ideas how to resolve or bypass ? Thank u

    Monday, November 13, 2017 5:33 AM