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
4 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
17 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; ...
1
vote
1answer
53 views

Toolbar and Title Bar not present in Excel access webpart

I have added Excel access webpart to a page in sharepoint. when i click on eidt webpart properties, i can't see all the properties which i should see by default. any idea why? i can just see ...
3
votes
3answers
21k views

Excel document opening in browser (unsupported features)

I am using Sharepoint 2010 and when users click on an .xlsx document in a document library it says the following: "The workbook cannot be opened because it contains the following features that are ...
1
vote
1answer
454 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 ...
2
votes
2answers
100 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 ...
0
votes
0answers
21 views

Overlay in Excel Services Chart

I have a chart in an Excel document that I am displaying on a Web Part page. In Excel, I was able to draw a text box and overlay a percentage. However, these types of objects are not supported by ...
4
votes
4answers
3k 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, ...
1
vote
1answer
933 views

SharePoint 2013 Excel Services & External Data Refresh Failed

I need advice how I can fix problem with Excel external data connection. I have an excel file, which have connection to SSAS. Excel file "refresh all" works fine if I download it out from SharePoint. ...
0
votes
0answers
14 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
8answers
21k 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 ...
7
votes
6answers
25k views

Unable to open office files in Office client

While trying to open an excel document stored in "Shared Documents" library, the excel application opens up with a login prompt, to which I passed the login credentials of the site. After which the ...
0
votes
1answer
767 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 ...
1
vote
2answers
45 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 ...
5
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
2k 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
23 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
1answer
1k views

An error occurred while loading the model for the item or data source 'EntityDataSource'

I use SQL Server 2012 SP1 U8 and SharePoint 2013. I configure Excel Service and Performance Point Service and PowerPivot Service. I create an Excel File`that fetch data from Data Warehouse in ...
2
votes
1answer
1k views

SharePoint Online & Excel Services -> unable to refresh data connections

I'm trying to create a few very simple reports based on my SharePoint Online data using Excel. I've got as far as getting the data into Excel and creating my report, and now I'm trying to upload the ...
1
vote
0answers
16 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 ...
2
votes
0answers
52 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
29 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
24 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
0answers
154 views

Sharepoint 2013 Errors 6309(timer) & 8059(Claims Authentication) Excel Web App Error

The issues I am getting is a 8059 error "and exception occurred when trying to issue security token" it then asks me to turn on "includeexceptiondetailsinfaults" whichIi try to do on the security ...
0
votes
1answer
139 views

SharePoint 2010 - Excel Web App error “An error has occurred. Please try again.”

On one of SharePoint sites on our server. While opening few .xlsx files users(including me) are getting the error "An error has occurred. Please try again.". When the user click's on any of these ...
0
votes
1answer
38 views
0
votes
2answers
146 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
49 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
50 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 ...
1
vote
3answers
1k 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
2answers
127 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
32 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
53 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
31 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
408 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
40 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 ...
3
votes
2answers
2k views

Be careful. The query to get the data might be unsafe so you should only refresh the workbook if you trust its source

I use SharePoint 2013 and Excel Services and SSAS I load an Excel file to SharePoint Document and then I use that in Performance Point Service to create an Excel Report. I then use this report to a ...
0
votes
0answers
25 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
15 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
382 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
16 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
58 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
92 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
125 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
566 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
121 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
29 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
22 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 ...