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
1answer
77 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
27 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
28 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
401 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
24 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
54 views

File Access Method setting under Excel Service settings in SharePoint

Under Excel Service settings in SharePoint, File Access Method (The authentication method used by Excel Calculation Services to retrieve workbook files from all non-Microsoft SharePoint Foundation ...
0
votes
0answers
53 views

EffectiveUserName for Excel Services in SharePoint 2013 not working as expected

I have followed the steps mentioned under this MSDN article. Under Roles for SSAS DB, I have added only User A and User B, not User C. My SharePoint site has 3 users under the Site Owners. --> User ...
0
votes
0answers
44 views

Is it possible to edit excel file on SharePoint online from iOS app?

Currently, I am developing an iPad app which can manipulate excel file that is stored on SharePoint online service. I am able to retrieve data from excel file using Excel Services REST API, but when ...
0
votes
0answers
30 views

Duplicate menu in excel report in performance point service of share point 2013?

I use SharePoint 2013 and Performance Point Service. I change menu my menu in my Master Page file with one static menu. <div style="width:550px;background- ...
0
votes
0answers
219 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 ...
0
votes
0answers
258 views

Problem connecting Sharepoint 2010 to SSAS through a RSDS

As the title says, I'm trying to create a Report Data Source on Sharepoint 2010 where I have an SQL2012 instance with the PowerPivot, SSRS and the sharepoint add-in configured. I choose "Microsoft ...
0
votes
0answers
27 views

What is required permission to apply the filter on the PivotTable on the Excel webpart?

We have an excel webpart on the page which displays the Pivot Table from the workbook is stored on the document library. As I have the full control, I could see the options to apply filter on the ...
0
votes
0answers
51 views

Disable Excel Services

We have recently upgraded from Standard to Enterprise SharePoint 2010. However, Excel Services loads when you try to open an XSLX document and you're using FireFox or Chrome. IE will open in the Excel ...
0
votes
0answers
39 views

how to get used range in excel web service

In SharePoint 2010 visual Web Part I am trying to uploading an excel file in document library and then read that file and write it to the list. But i am unable to get the used when reading the data ...
0
votes
0answers
23 views

SharePoint 2010 & Excel & Refresh from access databse

I have an excel document that's hosted inside of a SharePoint Server 2010 document library. This particular excel document has a ODBC data connection to an access database, where the access database ...
0
votes
0answers
42 views

Scheduled update of Excel workbook data in SharePoint

We have a number of Excel workbooks that retrieve data from SQL Server. These queries are very intensive, so someone opens each of the workbooks and does a manual refresh each day. Other staff can ...
0
votes
1answer
69 views

How to use SharePoint 2010 web chart to create a chart with 3 columns, I met 2 problems, can you help me?

This is my Excel file, with 3 columns Date Ongoing Pending 4/22/2013 4 4 5/22/2013 4 4 6/23/2013 4 4 6/24/2013 4 4 6/25/2013 4 4 ...
0
votes
0answers
703 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
106 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
170 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
296 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
357 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
57 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
795 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
176 views

Are Sparklines Viewable via excel services and Business Intelligence?

I have an excel report with SparkLines in it. When I view the file through excel services (aka in the browser), all looks fine and dandy. But when I try to browse the file via REST services, the ...
0
votes
1answer
120 views

Excel Calculation Services - Excel Web Apps

We're trying to co-author excel workbooks but only have Standard CAL/Sharepoint 2010 Standard Server license. Its my research so far that to have co-authoring for Excel, we would need to use Excel ...
0
votes
1answer
545 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
1answer
197 views

Create new Worbook with Excel Services

I want to generate an Excel File with SharePoint. I can make a refernce to ExcelServices an want to use the funtion NewWorkbook. But i get the error : Soap Exception: You do not have appropriate ...
0
votes
0answers
175 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
605 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
529 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
448 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
300 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
438 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