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

1
vote
0answers
223 views

When I try to view Excel in browser I got error We don't know what happened, but something went wrong

When I try to view Excel in browser I got error We don't know what happened, but something went wrong. When I try to edit file is ok? In event log I get: There was an error in communicating with ...
1
vote
4answers
2k views
1
vote
1answer
234 views

How to connect an Excel file to a Data Connection Library?

In the article here, it states that an excel file can connect to a .odc file inside a DCL. I've researched for a bit and finally stumbled upon a solution that involves having to modify registry ...
0
votes
1answer
1k 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
0answers
15 views

Data Provider for SQL Server Analysis 2014 - SharePoint 2013

Which data provider or requriments are needed to connect Excel Services workbook to external data SQL Server Analysis 2014? I'm not able to refersh data?
2
votes
1answer
629 views

External Data Refresh failed - Unable to refresh list data in Excel Web Access WebPart

I have created a PivotChart in Excel workbook that fetches data from a SharePoint list using "OData Data Feed". When refreshing the connection in Excel 2013, the updated data is displayed in ...
0
votes
0answers
145 views

Restore Errors on Sharepoint

I got up backup a server. And I want to restore the backup to nother server. But I got this error and my restore job is failed. Object Excel Service Application failed in event OnRestore. For ...
3
votes
3answers
3k views

How to create an auto-updating chart from a Sharepoint list

Is there a way to create a chart/graph from a Sharepoint list, whether through Sharepoint graphing or MS Excel, so that the chart will automatically update when the data in the list changes? I've ...
2
votes
1answer
535 views

“Open in Visio ” & “Open in Excel” is not working, and I will get an error message

I have the following inside my SharePoint server 2013 :- EnterPrise Wiki site collection. i have both "Excel services Application "& "Visio Graphics Service" running correctly. The problem i ...
1
vote
2answers
233 views

Excel services refresh using Claims based NTLM?

I am able to upload reports in a sharepoint library that have embedded data connections to a cube(SQL2008\AnalysisInstance). We are not using power pivot. We are running Sql 2008 standard version. ...
0
votes
0answers
12 views

Cannot Refresh Excel in one Web Application with Kerberos and without

After moved web application from test farm to production, excel file with connection to OLAP db cannot refresh. The excel servcie account has permissions in db. In the same web app is performancepoint ...
0
votes
0answers
72 views

Licence error after installing Office Web Apps and suppressing XLXS and XLSM

I get the following error: In german: 'Application error when access /_layouts/15/xlviewer.aspx, Error=Leider wurde Ihre Lizenz zum Verwenden dieses Features nicht gefunden. Wenn Sie wissen, wer die ...
0
votes
1answer
34 views

I need help - some excel docs not opening in sharepoint

Many excel files in our libraries are no longer able to be opened. They can be downloaded via the drop down menu, but will not open with a click as they should be. The pop-up message we get is; ...
2
votes
2answers
259 views

Cross domain issues accessing Excel Services in a Sharepoint App

I have an Sharepoint app hosted at: https://app-xxxxxxxx.sharepoint.com/sites/my-site/ And I want to retrieve the json representation of an excel document using the Excel Service Rest API hosted ...
4
votes
4answers
4k views

Excel Services - Using parameter for query

I have an excel spreadsheet that returns data based on a cell value. In essence, it's Select * from table where field = Sheet2!A1. All works like expected, except when I publish it to SharePoint, ...
0
votes
0answers
83 views

In an Excel file. The data connection uses Windows Authentication and user credentials could not be delegated

I have an Excel Spreadsheet with a connection to a Sql Server table. The connection uses my domain account. If I try to update the connection I get this message: The data connection uses Windows ...
3
votes
7answers
23k views

Excel Services 2010 Error - “The workbook cannot be opened.”

I enabled Excel Services and added a Excel Web Access viewer to my page. It's just a simple spreadsheet (which incidentally works fine on my standalone development server) that displays the error ...
1
vote
2answers
104 views

Excel web service web part in sharepoint 2013 app

Is it possible to add Excel service web part in SharePoint 2013 app? My intention is to create dashboard with graphs and charts (from excel which was published) in the app. Please help me with any ...
1
vote
1answer
248 views

Lock Cells to Certain People But Give Access to others in a Live Excel Online Worksheet

My company has switched from Google Docs to SharePoint and Office 365. One of the things that we need to be able to do is have a collaborative live/dynamic spreadsheet that give lock some cells to ...
1
vote
0answers
28 views

Excel Workbook webpart filtering display issue

Has any one experienced an issue with Excel workbook WepPart not displaying the filtering box and items? What it does look like: What it should look like: This is not displayed until I select ...
4
votes
0answers
108 views

SharePoint Online List limitations

Is it just me or is it really strange that SSRS 2012 still does not support Claims based authentication or OData connections? Anybody know of plans? Reasons for such a hole in the strategy? Part of a ...
0
votes
0answers
65 views

JSON feed for Excel data?

There is an OData feed to get data from an excel workbook via Excel Services. However, it only supports ATOM, and not JSON. is there another way to get JSON data for an excel workbook? Along these ...
0
votes
1answer
72 views

How to exctract filtered items from SharePoint List to Excel

I'm using Javascript and AngularJS to get all data from a SharePoint list in JSON and displayed it into a table. User can sort it, filtered it and etc. There is a really nice paggination. Everything ...
0
votes
1answer
178 views
0
votes
2answers
422 views

Excel Services REST API returns 401 Unauthorized in Workflow

I am trying to make a call to the Excel Services REST API in a workflow to retrieve information on a workbook's charts. The URL format is ...
0
votes
0answers
566 views

Cant open excel workbooks in browser sharepoint 2010

Okai I am currently facing an error when i try to open excel files in browser . it gives the prompt "The workbook can not be opened". Upon checking the logs I found the following entries in the log ...
1
vote
0answers
67 views

Excel data doesn't appear, in the Excel Web Access

I've added an Excel Web part into my page. I did check out this excel workbook. But, when I want to run my page , I'm getting as follows error. Also,when I want to open xslx file in my desktop, the ...
2
votes
2answers
326 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 ...
0
votes
1answer
44 views

How to add new service application with Central Adminstration

I want to excel document into my webpart in sharepoint 2013. First, I added a webpart in my page as follows. Then I clicked "Click here to open the tool pane." and I added workbook URL and OK. But ...
0
votes
0answers
83 views

Update Excel document without checking in and checking out

Suppose we upload a shared Excel document in the SharePoint 2013. If we try to edit it allows to edit for a windows user and allows to save it. If then another windows user tries to edit the same ...
0
votes
0answers
73 views

Open office documents in browser sharepoint 2013 azure

We have a sharepoint 2013 site in which i want to open documents(majorly word and excel) in browser instead of application. Please not i am not considering Office web app. Instead i am interested in ...
1
vote
2answers
616 views

Excel Web Access Web Part won't display workbook

We've recently upgraded from SharePoint 2007 to 2010 and we are trying to get the Excel Web Access web part to work. Excel Services is running if that's required, the workbook location is configured ...
0
votes
0answers
102 views

Excel Services Form working in Infopath preview but not Sharepoint

For the past 2 days i have been banging my head against the screen trying to solve this issue with Infopath 2010, Sharepoint 2010 and Excel Services. I am creating a pretty simple form which uses an ...
0
votes
0answers
44 views

Excel Web access webpart url

I am following an Article to solve a "The Workbook cannot be opened" that appears on my webpart when I load the document. It mentions getting the url of the webpart, in order to complete a powershell ...
0
votes
0answers
48 views

How to set boolean value in excel sheet cell?

I have written a procedure which inserts data from excel sheet into SQL Table. I get an error which says: "Cannot insert the value NULL into column X". This column stores boolean value. It is the ...
2
votes
0answers
13 views

Poll app 2010 producing graph [closed]

I am creating a poll app in 2010 just wondering what the best way would be to produce a graph would be. would I be able to do it using excel
1
vote
1answer
515 views

How to use excel services REST api in Sharepoint Hosted App

I need to call excel service rest api as follows on the 'Summary' library in hostweb ...
0
votes
0answers
70 views

Newly uploaded Excel workbooks not showing in Excel Web Access in SP2007

Weve been having an issue recently regarding workbooks not showing within Excel Web Access on Sharepoint 2007. EWA is displaying a message stating "The workbook that you selected cannot be opened. ...
0
votes
0answers
100 views

Insert SharePoint metadata into excel cell

What is the best way to create a system that inserts metadata fields of the document in SharePoint in a cell in Excel? I've done this behaviour multiple times in a Word document using the 'Quick ...
0
votes
1answer
313 views

How to access Excel PROTECTED spreadsheet in SharePoint Web Access Web Part in SharePoint2013?

I have excel file which is protected by password. I need to access Sheet 1 on SharePoint Web Part Page on Dashboard. While I add protected I can not able to Excel Sheet is corrupted as per below ...
0
votes
0answers
250 views

Excel Services licensing error

I have one client getting this error on a page that's using Excel Services: Sorry, we couldn't find your license to use this feature. If you know who manages the licenses for your organization, tell ...
1
vote
1answer
1k views

Power Pivot and Power View do not work for Excel workbook with external connection

I have SharePoint 2013 with Power Pivot and Power View. It's based on SQL Server 2012. They seem to be configured properly as they work fine with Excel 2010 workbook that contains tabular model that ...
2
votes
1answer
217 views

Convert Single line of Text to Lookup type after importing data from Excel file

I imported the data from excel file, but some column data type I need to change from single line of text to Lookup value. How to do this? I am using SharePoint 2013
0
votes
0answers
46 views

Reading cells from excelsheet into info path code behind

We have an excel sheet that we would need to read cells from in the info path code behind. This excel sheet has data validations, due to which we would not be able to use excel services (web service) ...
3
votes
1answer
27 views

Reusable Tasks - moving an process from excel workbooks to SharePoint

My team use a SharePoint 2013 team site. Currently when we deliver training we use an excel workbook which tracks student names, and tracks their scores and has a standard task list of content that ...
1
vote
1answer
89 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
0answers
61 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
48 views

Excel Web Part/Excel Spreadsheet not refreshing from week to week

I have a Excel spreadsheet that is pulled from a SharePoint list (our helpdesk ticketing system), in which I have a PivotTable summarizing the data in a named table, which is then put into an Excel ...
0
votes
0answers
45 views

Removing permission granted for excel services

When setting up Excel services with an unattended service account, one step is to grant the account access to the web application(s) database that will use the service with PowerShell. $webApp = ...
0
votes
1answer
668 views

Reading excel cell value in Excel Web Access Webpart

I need to read excel cell value.Excel web access webpart is used to display excel file stored in a SharePoint 2013 document library.I need to use Jquery to read the data of excel file currently ...