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

2
votes
0answers
142 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: ...
2
votes
0answers
81 views

SharePoint Onine List as Datasource to Excel Services / Business Intelligence in SPO

Trying to join 2 SharePoint Custom Lists sources into an excel Services Graph. If so, any BI option for formating list data on an SPO page? Possible now under SPO 2013 A3 license? Confused about ...
2
votes
0answers
136 views

Can I access excel file from a remote sharepoint server in my Excel Web Access web part?

We are developing an organization level dashboard in which we are using Excel Web Access web part to display part of or entire excel workbooks containing charts. Problem is, the corresponding actual ...
2
votes
0answers
754 views

Excel Web Access web part real time update

I have the following scenario and would very much appreciate any advice: I exported a list /System/Examples to Excel and then saved it as Testing.xlsx to a different document library: ...
2
votes
1answer
1k views

Issue with Excel Services work book with Integrated Security but logged in from Claims auth

I am trying to use an embedded Excel work book within a SharePoint site. This workbook connects to SSAS using Integrated Security. It works correctly when I log in to SharePoint using windows ...
1
vote
2answers
4k views

SharePoint 2010 Co-Authoring Excel

Are there any other settings, besides disabling "Check Out", to enable Co-Authoring in Excel? When I open Excel, all I get are the options in the image I attached. I do not get the "Edit" option ...
1
vote
3answers
6k views

EXcel Web Access - web part Error

I asked this related question in stack overflow, Hence this forum is dedicated for sharepoint, Thought to ask here!! I got to know how to get the Excel using sharepoint Excel web access webpart. ...
1
vote
1answer
19k views

Excel Services Error in SharePoint 2013 - Unable to Open/Edit Excel Files

Every time I click on a excel file I am receiving a popup message mentioning - We're sorry. We ran into a problem completing your request MS Word is working fine though. I performed all the ...
1
vote
1answer
11k views

Excel error in sharepoint

I tried to open this Excel worksheet in Sharepoint and got the following message. The Window cannot be opened because it contains the following features that are not supported by Excel in the ...
1
vote
1answer
3k views

Convert the Infopath Form into PDF or Excel in SharePoint 2010?

We have designed an Infopath Form and published as a document template on a library. Now, we would like to add a feature to export the InfoPath Form details to Excel or publish the InfoPath Form as ...
1
vote
1answer
72 views

How to collect data from many users

In our company from time to time there are polls (like 'Name, Employee number, Will you attend the christmas party? Dinner preference?' ... ) which are typically handled via Excel sheets shared in a ...
1
vote
2answers
1k views

Can a C# web service access an Excel Services workbook?

A bit of background: I have an InfoPath browser form that I have connected to a C# web service that I've written. I have an Excel Services worksheet published in SharePoint as well. What I'd like to ...
1
vote
1answer
3k views

Sharepoint foundation-Need to show excel file contens within sharepoint page

Scenario: Sharepoint foundation 2010. End users would like to view the EXCEL documents within sharepoint page and not loosing the typical excel functionality. The USERS would open EXCEL file (using ...
1
vote
2answers
343 views

Parsing Excel doc in SharePoint

In my current project I have requirement to upload an excel file, parse it and send the data to a third party system. I have no need to persist the file either in SharePoint or on disk and I don't ...
1
vote
1answer
317 views

Error in the data model when refreshing external data in Excel

I have a BI Center site, I'm trying to open an Excel sheet in the PivotView gallery but it gives me this error: Workbook cannot be opened I have uploaded the Excel sheet in another library but ...
1
vote
1answer
20 views

Doing calculations in Excel Online with user permission “View Only”

I want to share Excel files in a SharePoint library. The users shall only be able to open the files in "Excel Online", but not to download them or the open them offline. Also the original file ...
1
vote
1answer
74 views

Can download a copy even with View Only permissions

We have a weird bug in which Excel Services allows users with View Only permissions to download files even without permissions to do so: At first, you might think that this is a problem with ...
1
vote
1answer
294 views

Data Connection does not refresh in Excel

I have a SharePoint list; Exported into Excel file and set the property to refresh Data Connection every time the file is opened. It worked very well in Excel installed on my system but when I ...
1
vote
2answers
421 views

Open Excel file in browser returns error

I have configured an excel document library to open in the browser. The file was published to the document library. The document library was set to open the file in the browser. When the file is ...
1
vote
1answer
303 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 edit webpart properties, I can't see all the properties which I should see by default. Any idea why? I can just see ...
1
vote
1answer
2k 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
257 views

How I Can Add SSAS TO Excel Services Application Trusted Data Provider in Share Point 2013?

I use SharePoint 2013 and I want create some Excel Report from my SSAS database. For configuration my Excel Service, I go to Central Administration and Manage service applications, then Excel ...
1
vote
1answer
671 views

Excel Services - Disable Refresh warning

I'm trying to figure out how to disable the refresh warning used within Excel Services. Everytime I load my page I get the following: My first port of call was to check the trusted file location ...
1
vote
1answer
3k views

Unable to refresh data for a data connection in the workbook.

I am trying to use an Excel Web Part that connects to a list in Sharepoint 2010. On my local drive the spreadsheet updates when I open it and all is well but when I uploaded to sharepoint the data ...
1
vote
1answer
480 views

If a user can't read Excel file, can they still view Chart Web Part created from it?

Title sums it up. I would just try it myself but my test environment is down and I figured I might get a speedier response here than to wait for that to come up. If users don't have permissions to ...
1
vote
2answers
719 views

Excel web access webpart throwing javascript error ( in ewamoss.js) in IE10

I am using Excel web access web part to display Excel reports in Sharepoint 2010. It's working fine with IE9. When I am loading the report in IE 10, it's throwing the error "Unable to get property ...
1
vote
3answers
4k views

Unable to Refresh the Excel Connection in Excel Webaccess Webpart

I am using an excel workbook with pivot in it. I am using the Excess webpart to display it. As I click on the Refresh all data connection. It throws an error.The scree shot is attached. I have ...
1
vote
2answers
267 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. ...
1
vote
2answers
5k views

Excel Services permission error

I'm using SharePoint 2007. Some users are getting an error when trying to open a spreadsheet from the SharePoint. You do not have permissions to open this file on Excel Services. Make sure that the ...
1
vote
1answer
887 views

Programmatically clear an Excel web access session

I have an Excel workbook in a document library which is programmatically overwritten with a new version every so often. I have set up a web part for Excel Web Access to display the workbook on a page. ...
1
vote
1answer
329 views

Office Web Apps Word - Configure trusted locations

It is possible to configure the trusted file locations for the Word Web App on SharePoint 2010? I only can find the settings to configure the supported file formats at the Word-Service Application ...
1
vote
1answer
642 views

Excel Web Access & VSTO

I created an Excel workbook in Visual Studio 2010 using VSTO, and it fills a table with data retrieved from a WCF service. The service was added to the project using the standard "Add Service ...
1
vote
4answers
3k 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
1
vote
1answer
198 views

Excel Web Services Error

I have uploaded an xlsx file that I would like to use EWA to display using Excel Web Services. I have confirmed that the site is a trusted location and Excel Web Services is configured correctly from ...
1
vote
1answer
682 views

401 authentication error when calling OpenWorkbook method of ExcelService.asmx

We are trying to call the Excel Services web service using SOAP with a Sharepoint/domain admin account. I see 401.2 errors in the IIS logs. There is no user name specified there. We are using ...
1
vote
2answers
529 views

Excel Web Services/Pivot Filters not functioning and MOSS 2007

I am currently struggling with an issue with Excel Web Servces and pivot tables. We have several site collections in which we expose pivot tables with filters through EWA web parts. The issue is ...
1
vote
1answer
15 views

Cannot add parameter to Excel Services

In the Browser View Options Parameters in Excel, why can't we select a desired named field when we click Add?
1
vote
0answers
24 views

Excel Web Access print button is disabled

The print button in the excel sheet that I have uploaded to a powerpivot gallery is not enabled. How do I enable it? File > Print show a print friendly view According to this msdn article ...
1
vote
0answers
54 views

Read the entire Excel file in atom format using Excel Services

I am trying to read Excel file stored in Document Library using Excel Services. I need to fetch the entire workbook content in a single request call. I have tried using Ranges using it like ...
1
vote
1answer
48 views

Can I access office.js from SharePoint 2013 content-editor web-part like I can Ewa?

I have HTML and JavaScript that run just fine in a SharePoint 2013 content-editor web-part, from which I can access the Ewa.EwaControl object ...
1
vote
1answer
131 views

Can not refresh external data in Excel file which connected to Postgres via PowerQuery in Excel Web App

We have an Excel file which is connected to a postgres database via PowerQuery. PowerQuery needs npgsql provider for it. When I open file locally on my computer and try to update data - everything is ...
1
vote
0answers
20 views

How to get an Excel table's Summary property from JavaScript on the client side using the Ewa namespace

Background: The value of the Summary property corresponds to the setting of the Description box in the Alternative Text dialog box, which is displayed by right-clicking on an Excel table and then ...
1
vote
0answers
23 views

How can I have end-users visualizing different dimensions from the same Powerpivot on same excel file?

I need help to understand if it is possible to have end-users visualizing different dimensions from the same excel file published in Sharepoint 2013. I have a data warehouse in SQL Server 2012 and ...
1
vote
0answers
75 views

Excel Mobile Viewer Feature removal troubles in 2013 upgrade

I am in the process of upgrading from SharePoint Server 2007 to Server 2013, and Excel Web Services is throwing a spanner in the gears. I have 3 environments: SharePoint 2007 (SQL 2005) in ...
1
vote
0answers
95 views

Power Query Data Refersh

I used power query in the MS Excel to import data from SharePoint online List, and create a dashboard by using the data of that list. Everything work perfectly when I used that excel on my desktop, ...
1
vote
0answers
13 views

How to identify spreadsheets created in Web Apps?

We've hit the snag of not being able to use PowerView with Excel Web Apps: ...
1
vote
0answers
32 views

Updating Excel Connection using SharePoint Excel Services

I am developing a SharePoint Webpart, which asks user for basic information and SQL Connection. As user fills information and click's Generate Report button an excel report is generated which has ...
1
vote
0answers
20 views

SQL Error 18456 state 8 on SharePoint Excel Services

I installed SQL Analysis Services. I want to test it via Excel Services on SharePoint. I created new account with which I can easily login to SQL Server Management Studio: the username and password ...
1
vote
0answers
56 views

Excel Services In External Website

I'd like to render an excel workbook (specifically a pivot table) using Excel Services on our department's internal website and I am not sure how to do it (and I guess I am not searching correctly on ...
1
vote
0answers
32 views

Is it necessary to configure Excel service application and secure store to view excel reports in SharePoint?

We are using SharePoint 2013. Now we need to add some excel sheets and excel reports onto the SharePoint page. So we have seen that there is a Excel viewer webpart. I was wondering whether it is ...