0
votes
0answers
9 views

Excel and PowerPoint to talk via SharePoint Libraries

We are looking into a way for an Excel file and PowerPoint file to exchange data. I'm thinking Excel Web Services, OpenXML, SharePoint Office Apps and/or maybe CSOM. Requirement is coming up to: ...
0
votes
0answers
8 views

Excel Services transparent similar to Reporting Services

When using the Reporting Services web part we have found that we can make the background of the report transparent so that what ever back ground is used in Sharepoint will show through the table. Is ...
0
votes
0answers
57 views

Can I toggle Named item in one Excel Web Access web part via a filter web part

I have two charts that are named as follows in one workbook: ChartX (line chart of revenue) ChartY (bar chart of happiness) The workbook has been uploaded to our Sharepoint sub-site. In a web ...
0
votes
0answers
25 views

Can I suppress Excel Services alert “Query and refresh Data”

We have a sub-site with a doc library "Reporting". Saved there we have several xlsx files. Within the same sub-site we have a Data Connections library with odc' files linking through toOLAP` cubes. ...
0
votes
1answer
36 views

Setting to enforce use of Excel Services rather than Excel Web App

Our site and sub-sites are defaulting to Excel Web App rather than Excel Services. We require Excel Services. I think maybe I hit a setting somewhere at the root which has caused this change. Where ...
2
votes
1answer
152 views

External Data Refresh Failed - which setting is causing this error

I'm getting this error message when trying to refresh a workbook. The odc file is saved in the Data Connections library of the sub-site. The excel olap pivot report is saved in a document library of ...
0
votes
0answers
26 views

Uninstall/reinstall PowerPivot

I am thinking I need to unintall/reinstall PowerPivot on my SP 2013 (single-server) farm, due to the fact that I mistakenly installed it when I had the wrong version of Analysis Services installed on ...
0
votes
0answers
354 views

PowerPivot Management Dashboard: Workbooks do not update in Excel Services

[Running SP 2013 Enterprise SP1 w/ SQL Server 2012 SP1] I having a couple problems with the PowerPivot Management Dashboard. (Well, maybe more than a couple but I am focusing on these right now.) If ...
0
votes
0answers
23 views

SP2013 - Calculate a coaching Score from a sharepoint list

Scenario : We use a sharepoint list with a custom InfoPath form to Quality Coach our colleagues. The list itself is a series of questions with Yes (Y) , No (N) and Not Applicable (X) as options. We ...
0
votes
2answers
405 views

Import File from SharePoint and Link this file with SharePoint (File- Excel File)

I am using SharePoint 2013 and Microsoft Office 2007 or above. Scenario: I upload a Excel file to a SharePoint 2013 list. Now, I want to import this Excel file from this SharePoint list back to ...
0
votes
0answers
205 views

Sharepoint 2013 Excel Web Access Web Part- display workbook's worksheet data per web part

I am trying to display data via the SP 2013 Excel web access web part and a workbook generated by BI360's excel plugin.The challenge is that as it's a new workbook each monthly reporting period, I ...
1
vote
1answer
408 views

Thumbnails/snapshots don't show in PowerPivot Gallery when the document refreshes on open

I have several excel documents containing PowerPivot tables. They all connect to a SSAS Tabular service (on SQL 2012) via a .odc connection file, all of which is hosted on SharePoint 2013, using the ...
1
vote
0answers
20 views

Make First Sheet Display in Excel of Sharepoint in Browser

I have a Excel Web part and make an excel appear in browser throught this web part. There is 4 sheets in excel but when I open the page , firstly the third sheet appears but not he first sheet. How ...
0
votes
1answer
65 views

Is it possible to specify content database name while creating the Excel Service Application using powershell script?

I want to create the Excel Service Application as it is required to use the Excel Web Access Web Part. Firs I tried to create the application using sharepoint but GUI not providing facility to specify ...
0
votes
1answer
207 views

Excel Services - Disable Refresh warning

I'm trying to figure out how to disable the refresh warning used within Excel Services. Everytime I load my page I get the following: My first port of call was to check the trusted file location ...
1
vote
0answers
145 views

SP2103 Excel-Services Freeze Panes / Headers

Do anyone know a simple solution to freezing the headers in an Excel file that is published on a SharePoint 2013 portal.
0
votes
1answer
163 views

Implementation of power view in sp 2013 - Pain Points and Ideas

Can anybody please give me some painpoints of using PowerView in sharepoint 2013. Recently in our project we are planning to upgrade our site from SP2010 to 2013. In SP2010 site we have lots of ...
0
votes
1answer
761 views

“Access Denied” when attempting to view Excel workbook

After uploading a workbook to a newly created PowerPivot Gallery, attempting to open the uploaded workbook displays: I am logged in as a Site Collection Administrator and have verified that Excel ...