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

3
votes
1answer
2k views

Error while opening sharepoint list in datasheetview and exporting to excel

I have a List which is having around 14000 items in it.while opening that list in datasheet view it is giving error . Below is a summary of the issue: After selecting datasheet view : "Cannot ...
2
votes
1answer
43 views

Refreshed SharePoint 2013 charts

I'm trying to understand what would be the best way to display up to date/real time data coming from a SharePoint List in a chart, if it's possible at all. Why? Today I was quite surprised to learn ...
2
votes
1answer
1k views

Cannot create a PowerPivot data connection (PerformancePoint Services in SharePoint Server 2013)

I can create data sources that connect to SQL Analysis Servier 2012 instances, but not to the PowerPivot instance. I followed the instructions here: ...
1
vote
1answer
19 views

SharePoint 2010 Multi Tenant - I need Excel Services

We are running SP in Multi-Tenant mode for a few small clients. I need Excel services enabled for two of the tenants. What options do I have and how do I do it? I have been looking at documentation ...
1
vote
1answer
88 views

Since last patch, unable to open excel documents and word documents can only be opened by dropdown

We performed updates to the SharePoint Portal, SharePoint Foundation, Office Sharepoint Server, Excel Services Component, and Word Server on 03/16/2014. Since then, we are unable to open Excel ...
1
vote
1answer
316 views

Why does SharePoint 2010 Excel WebPart not find Excel spreadsheet in Share Documents?

I have a SharePoint 2010 single instance. The Web site has an Excel worksheet in Shared Documents, which I can navigate to as a user. I have enabled Excel services. I have activated Excel services ...
1
vote
1answer
1k views

Not able to refresh External data in Excel Sharepoint 2010

I am not able to refresh the data in Excel when see the excel report in browser. When i press Refresh All options the page get refresh but no updation in data is reflected. Actually i have two ...
1
vote
1answer
208 views

issue with Excel Services in SP2010

I have created a Excel and enabled the connection to external sQL database through Secure store service and created the odc file . When i open the excel in sharepoint it refreshes the data and it is ...
1
vote
1answer
49 views

Excel Services User Defined Function returns #NAME?

I've followed all the steps as described in numerous blog posts, including the MSDN Walkthrough, on setting up User Defined Functions in Excel Services. However, I'm still getting "#NAME?" in the ...
0
votes
1answer
28 views

Excel Services data refresh does not return updated data from data source

I have an Excel include some data which from a SharePoint list. This excel is created by using "Export to Excel" button of the SharePoint list form. I created a pivot table in the excel based on the ...
0
votes
1answer
24 views

Sharepoint Excel Logic

I have an Excel spreadsheet that I would like to import onto Sharepoint. The import/export function is easy enough to use, however the math logic that four of the cells conduct in the Excel ...
0
votes
1answer
284 views

SharePoint 2013 - Excel Web Access - Can't Contact the server

I have a BI site configured with Excel and Reporting services and all the other required services. I have extended this site and all is fine when I use farm account accessing the site through ...
0
votes
1answer
67 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
1answer
105 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
1answer
171 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
186 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
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
49 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
38 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
0answers
208 views

Unable to refresh SPO 2013 Excel Web external oData source

First of .. I see the Excel Web access webpart on SPO 2013, but is Excel Services available on SPO 2013 and if so, where is it and how do you enable it? So, I have this cloud test users. I ...
0
votes
0answers
219 views

excel odata connection to sharepoint online custom list - How do I return all rows in an SPO 2013 to excel 2013

How do I return all rows in an SPO 2013 list to excel 2013? I'm trying other sources > odata and can get some things, but not all rows. ...
0
votes
0answers
669 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
0answers
163 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
0answers
172 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 ...