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
2answers
367 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 ...
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: ...
0
votes
0answers
13 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
12 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
1answer
461 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
5 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
11 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
4
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 ...
1
vote
1answer
263 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
6 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. ...
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 ...
0
votes
0answers
23 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
36 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 ...
1
vote
1answer
384 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 ...
0
votes
0answers
34 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 ...
0
votes
1answer
139 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
41 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
20 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
17 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
39 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 ...
0
votes
0answers
18 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
29 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 ...
2
votes
4answers
18k views

Excel links open files as read-only mode. How to change this to edit mode?

Does anyone have any idea why using the link on excel opens the file as read-only mode? How can I change the behavior to open as Edit mode? I checked almost all of the Document Library settings, ...
0
votes
1answer
341 views

Excel 2013 workbook will not open in client application from SharePoint, only browser

I created a protected, macro enabled, .xlsm workbook on excel 2010 that is meant to be edited by many people. I uploaded it on my company's SharePoint site (Not sure if it is 2010 or 2013, I can't ...
0
votes
1answer
80 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 ...
1
vote
3answers
2k views

Can an Excel file be used as an external content type?

or an external datasource? Can that be set up in SP Designer 2010
0
votes
0answers
28 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 = ...
3
votes
2answers
9k views

how to reload worksheet displayed in excel web access webpart

I have an XSLX file in a SP 2010 document library. I use the excel web access webpart to display it in a web page. However, if I modify the file, the changes are not immediately visible on the page. I ...
0
votes
1answer
138 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 ...
7
votes
6answers
23k 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 ...
2
votes
1answer
68 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
31 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
0answers
55 views

Using JSLink to add hyperlink to the Title - control if the link opens in browser or program

Due to business requirements I have a document library with BI reports (.rdl and .xlsx files) where I need to show the title while hiding the name. In order for our users to open the reports, I have ...
0
votes
2answers
73 views

How to know if Excel Services is available on SharePoint?

I'm using a Sharepoint 2010 server. Unfortunately, I'm not the administrator and I'm not able to connect with him. But I want to know, if Excel Services is installed and activated. I'm able to edit ...
0
votes
0answers
58 views

Excel Services data refresh through SharePoint OLEDB connection

I have set up Excel Services in SharePoint 2013 Enterprise Edition. The thing is, when for examle using an Excel Data Services Webpart, I can't refresh the excel connection to a SharePoint list (OLEDB ...
0
votes
0answers
23 views

'Invalid signature' in Excel 2007 when trying to open an Excel file

In SharePoint 2010, I'm trying to open an Excel 2007 document, there I get following error: "Invalid Signature". Still the certificate of the user is valid.
0
votes
0answers
45 views

ODC file cannot be opened in SharePoint 2013

I have an issue with ODC file cannot be opened in SharePoint 2013. Whenever I clicked the below ODC file (below yellow highlighted), it will prompt me for login 2 times. And after that, it will give ...
1
vote
2answers
652 views

Excel Services, Save As does not show Publish Options

I have created a document library and configure it to have a Document Template Excel Spreadsheet. When I create a new Document and then save the new Excel worksheet, by selecting File -> Save&Send ...
0
votes
0answers
82 views

SharePoint 2013 Excel Issues + ULS Logs

All of the Excel Web access apps on my SharePoint 2013 site fail to display correctly and show the common error We're Sorry we ran into a problem Completing your Request , Please try that again ...
0
votes
0answers
116 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
0answers
46 views

Excel cannot connect to the SharePoint list

I'm getting this error while exporting a custom list to excel. Any ideas why I'm getting this error? Here is the same question. Still couldn't solve this error. P.S.: "Check for server certificate ...
0
votes
0answers
19 views

CUBEFUNCTIONS failing in Excel Services but ok in Excel

I'm encountering a problem whereby we have Excel reports that are saved on our SharePoint server: when opened in Excel Services they show #N/A. if I then hit the button OPEN IN EXCEL the formulas ...
4
votes
2answers
487 views

Retrieving list items from multiple sites via OData with Excel

I want to build a report: with Excel 2013 + PowerPivot Add-In using data from SharePoint Online that should work in Excel Services (so I'm not able to use VB, Power Query, etc.) Report should be ...
0
votes
0answers
22 views

SharePoint 2010 Workbook cannot be open in Chrome [duplicate]

The Workbook cannot be opened because it contains the following features that are not supported by excel i n the browser: Data validation Sheet Protection I'm trying to open excel document in ...
1
vote
2answers
549 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 ...
1
vote
0answers
552 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
20 views

Excel services 2010 how to clear cell value

I am trying to interact with an Excel file in a SharePoint library.The Excel work book is always present at the library. When I do an upload of Excel the cells get appended to the existing file in ...
2
votes
1answer
80 views

Unable to export all the data from Share Point list

In my Share Point list has 23072 records, but I am able to exports only 2000 records. It has multivalued, Lookup, Yes/No & Calculated type columns and around 64 columns are there. Any ideas, How ...
0
votes
2answers
129 views

Excel web services cannot open in browser

I have an odd issue where as some Excel files once clicked give me the option to open or edit and then some others when clicked launch directly into Excel Services within my browser. There appears to ...