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
265 views

MOSS 2007 Excel Services - Show all Rows and Columns?

We're running SharePoint 2007. Is there a way to disable the arrow navigation buttons in Excel Services and instead display all rows and columns in the worksheet so the user can use the browser ...
0
votes
1answer
593 views

Is it possible to set up an ODBC connected Excel spreadsheet on SharePoint 2007 with a Standard license?

I know that many database connections are possible with the Enterprise version of SharePoint Server 2007. Is it possible to make a custom solution to set up a connection? If it depends on the type ...
0
votes
3answers
486 views

How do Excel Services Sessions work?

We are using web services interface to access Excel Services. When we have two sessions that access the same spreadsheet, it looks like they see each others data. Is this how it is supposed to work? ...
0
votes
1answer
15 views

The documents on sharepoint will open in 'Read Only' mode even though i try to open in 'Edit' mode

The documents on share point will open in 'Read Only' mode even though i try to open in 'Edit' mode.
0
votes
1answer
39 views

Change Excel web access dynamically using javascript

I have a page with a button and an Excel web part. When I click on the button I want to load another Excel file in that web part. Is it possible to do this? Please suggest some ideas on it.
0
votes
0answers
15 views

Prevent “We're opening your workbook in Microsof Excel” message from being displayed

I have multiple environments with SharePoint solutions installed on them. Almost all of them are working fine except one that has an issue and don't know how to solve it. Each time I open an Excel ...
0
votes
0answers
15 views

Excel Ewa JavaScript - Embed Workbook Stored in Document Library

I am trying to dynamically embed a workbook into a publishing page on my SharePoint 2013 on-prem site using Excel Services ECMA Script. I am trying to use the Ewa.EwaControl.loadEwaAsync method, but ...
0
votes
0answers
32 views

Can we get Excel Pivot chart as an image in SharePoint 2013

I have a workbook which has a pivot chart and we are showing it in Excel services web part. Now my question is: Is it possible to access that chart (as an image) element? I know we can use REST api ...
0
votes
1answer
47 views

SharePoint List lookup from Excel file

I would like to know, whether we can look up for a value in an excel file within a SharePoint list. I know that we can setup look up within different lists within a site. But i would like to know, ...
0
votes
0answers
26 views

Excel Web Access Content Visible to User Which are not exist in Excel Slicer (Used Current User Filter)

I have used Current User Filter in Excel Web Access Sharepoint 2013. I have used Excel 2013 Data imported from Database. If Current Login User not found in Slicer then Excel Web Access shows Error ...
0
votes
1answer
12 views

Offline doc linking to sharepoint doc (specifically excel)?

I searched for an answer to this and the various answers left me confused, so I figured I'd come here now since I always get a reliable answer from this forum. I have Office365 and I use Excel Online ...
0
votes
1answer
40 views

Excel Online/Sharepoint survey won't load

At work we use a survey created through Excel Online/Office 365 to track issues our employees have with software. It's worked splendidly until a day or two ago when the survey just takes you to the ...
0
votes
0answers
26 views

SharePoint 2010 & Excel Services & Errors

Good Evening All, I've been trying to configure automatic data refresh on excel spreadsheet that's hosted within an Excel web part. My spreadsheet pulls data from a SharePoint list into a pivot table ...
0
votes
0answers
9 views

Create Excel from SPListItemCollection and upload to a Document Library

Here is the scenario, I have a Timer Job. It sends Monthly summary of a list based on certain filters. I am able to generate Datatable from SPListItemCollection that I get using CAML. I would like to ...
0
votes
0answers
55 views

SharePoint 2013 Excel WebPart

I created new excel webpart. I got this error : The trial period for SharePoint Server has expired. I researched on net and i found this solve : Run--> inetmgr-->Application Pools--> ...
0
votes
0answers
14 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?
0
votes
0answers
124 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 ...
0
votes
0answers
11 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
56 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; ...
0
votes
1answer
28 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 ...
0
votes
0answers
63 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 ...
0
votes
0answers
58 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
65 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
637 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
154 views

Move BI Center (Excel, PerformancePoint, PowerPivot) to other SQL server - SharePoint 2013

What way would be the best to move BI Center to other SQL server in SharePoint 2013? Thanks,
0
votes
0answers
465 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 ...
0
votes
1answer
42 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
67 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 ...
0
votes
0answers
77 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
95 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
42 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
42 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 ...
0
votes
0answers
67 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
95 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
279 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
228 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
0answers
44 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) ...
0
votes
0answers
58 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
46 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
3answers
4k 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
2answers
881 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
0answers
43 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
65 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
83 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
106 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
84 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
52 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
99 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 ...
0
votes
0answers
120 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 ...