Excel Services is a server technology included in SharePoint. This shared service enables users to load, calculate, and display Excel workbooks on Microsoft Office SharePoint Server.

learn more… | top users | synonyms

0
votes
0answers
15 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
170 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
80 views

SharePoint 2013 - XLViewer

Is it possible to customize the XLViewer in SharePoint 2013 out of the box? By out of the box, you can find options in, say, Central Administration to modify the access rights such as allowing the ...
0
votes
1answer
215 views

Get-SPExcelServiceApplication Cmdlet not recognized during Powerpivot configuration

I am trying to run the sharepoint powerpivot configuration tool however I am getting a message saying: The term 'Get-SPExcelServiceApplication' is not recognized as the name of a cmdlet, function, ...
0
votes
0answers
55 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
0answers
46 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
672 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
33 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
0answers
1k views

Export Excel Table to Sharepoint List throwing publishing error?

I have a SP Foundation 2010 installation on windows 7. I created a OOTB Contacts list in SharePoint and tried exporting an excel (Office 365) table with various fields to this list. Note: The column ...
0
votes
1answer
133 views

Read from an excel Sheet and write to a List

My requirement is that, i need to upload data from an excel sheet to an existing sharepoint List in SP 2010.I will have 2 different Lists Like this. Then I need to compare Both the List and retrieve ...
0
votes
0answers
195 views

SharePoint 2010 List Excel Export Error

I have some problems about exporting a SharePoint List to excel. I'm getting "Excel cannot connect to the SharePoint list" error while exporting it to excel. There wasn't any error in the same list ...
0
votes
1answer
387 views

How to convert Sharepoint 2010 Chart web part to Excel?

I want to convert chart webpart's chart to excel format how it is possible?
0
votes
1answer
439 views

How to use ExcelServices in Sharepoint?

I want to use the Excel workbook in my SharePoint using ExcelServices. I have done all settings in "Excel Services Applications" & "Secure Store Service" in "Manage Service Application" option ...
0
votes
2answers
63 views

Starting Service Applications on SharePoint2010

I have noted that some of the service applications on my central admin are in stopped status, so i want to start them and don't no how to start them as I won't see any start option available on that ...
0
votes
1answer
1k 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 ...
0
votes
1answer
642 views

Excel Services Permissions

were setting up our SP2010 environment, and were looking to make use of excel services. Before we go all-in on excel services however, we have some causes for concern. Can anyone help define the ...
0
votes
0answers
217 views

Excel webpart limitations…?

Excel webpart limitations? Wanted to configure 8 Excel webparts on my SharePoint 2010 page, it works for 5-6 Excel webpart on the page and started throwing the error "Internet Explorer cannot display ...
0
votes
1answer
709 views

Excel Service Application - SharePoint 2010 (Performance Management)

I have a SharePoint 2010 farm with three servers :- Server 1 - WFE Server 2 - CA + WFE Server 3 - DB Cluster + WFE I have Excel Calculation Services Started on all the servers.These are my ...
0
votes
1answer
678 views

Powershell command for Excel Services?

Is there a powershell to restart the excel services? If yes, what is the syntax to restart the excel services.
0
votes
1answer
484 views

Opening Excel services session returns “Safe handle has been closed”

Has anybody else had problems with Excel Services in SP2010? I am trying to programmatically access Excel web services. To connect to Excel services, I am direct linking to the ...
0
votes
1answer
302 views

Excel Services delegation using Classic Mode Authentication

Every where I'm reading about setting up Excel Services for delegation so that it can connect to Analysis Services running on separate server is based around using Claims based authentication to ...
0
votes
1answer
444 views

Sharepoint dashboard and KPI

Is there any way to create a dashboard, and use KPI from a shared doc lib that contain excel sheets ? thanks
-1
votes
0answers
30 views

Excel VBA code to upload document into SharePoint online 2013

I'm looking for a snippet in VBA to upload a document (PDF file) into SharePoint online