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
1answer
50 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 (https://msdn.microsoft.com/en-us/library/office/ee589018....
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
27 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 I ...
0
votes
2answers
3k 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 ...
8
votes
1answer
267 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 ...
1
vote
0answers
59 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 ...
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 ...
0
votes
2answers
329 views

Create new Workbook using Excel Services

I want to generate an Excel File using SharePoint. I can make a reference to ExcelServices and want to use the function NewWorkbook. But I am getting the error which say Soap Exception: You do not ...
0
votes
0answers
19 views

SharePoint With PowerPivot Filters Missing

I upgraded existing Excel2010 spread sheet to excel2013 as part of SharePoint upgrade from sp2010 to sp2013. Everthing works fine but i dont see any filters being populated on sharepoint excel ...
1
vote
1answer
75 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
5answers
27k 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 ...
1
vote
0answers
79 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 ...
0
votes
0answers
24 views

Scroll bar not appearing in Excel webpart

I created one excel view with named item and inserted one custom scroll bar. but when i add the same excel report in excel webpart, scroll bar doesn't appear. any idea on this?
0
votes
1answer
59 views

Error viewing Excel sheets on mobile

I'm using SharePoint 2013, whenever I try to view an Excel file embedded in a SharePoint page through my mobile it gives me this message We can't start Excel mobile viewer because it may be ...
0
votes
0answers
39 views

Sharepoint 2013 BI (Excel Services) - How to target the filter to a certain audience?

We have an environment that contains Windows 2012 Servers and an Active Directory, SQL Server 2012 and Sharepoint 2013 on Premises. Powerpivot has been configured and the Business Intelligence Center ...
1
vote
0answers
113 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: http://blogs.technet.com/b/excel_services__powerpivot_for_sharepoint_support_blog/archive/2014/08/06/power-view-sheets-not-...
1
vote
0answers
33 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 "...
0
votes
0answers
197 views

Excel Web Access Web Part Resizing SP2013

I was wondering if there was a way to dynamically size the content of the Excel Web Access web part so it would resize with the device's zoom/ change from device to device. I don't want the web part ...
4
votes
4answers
5k 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
0answers
23 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 ...
0
votes
0answers
51 views

Excel services publication of refreshable table

I have a small problem, I have an Access database and I import from them one table with Power Query to the Excel sheet. The database is on my OneDrive server on SharePoint and this sheet (table in ...
1
vote
1answer
1k views

PowerPivot Data Refresh not Working After Adding Pivot Table

I have a spreadsheet with a powerpivot data model in sharepoint 2013 sp1 with sql 2012 sp2 for the power pivot instance. The power pivot data refresh works fine when scheduled, when the spreadsheet ...
3
votes
4answers
19k views

possible ways to import an excel spreadsheet to a sharepoint 2010 list?

I am running SharePoint Server 2010 and I have an excel spreadsheet of about 3000 rows / 30 columns, which I would like to import to a SharePoint list. I've seen on codeplex a free tool for MOSS/wss ...
3
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: http://technet.microsoft.com/en-us/library/...
1
vote
1answer
323 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 ...
0
votes
1answer
505 views

the table contains a string that is too long for excel to display. if you edit the long value some data might be lost

I have a SharePoint document library. On exporting to excel I get an error message the table contains a string that is too long for excel to display. if you edit the long value some data might ...
1
vote
0answers
61 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 ...
0
votes
0answers
139 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
2answers
3k 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 ...
1
vote
0answers
33 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 ...
2
votes
0answers
765 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: /System/...
0
votes
1answer
226 views

Pivot Table Source Data in Separate Excel Workbook stored on sharepoint

I have an excel spreadsheet on the sharepoint server with my Main Data that I want to analyze. I want to make a pivot table from this sheet that will update when the Main Data is updated, but I need ...
0
votes
1answer
183 views

Extract infopath xml data into excel

I have around 2000 InfoPath forms in SharePoint 2010 document library. I want to extract all forms in excel using macro. Any help?
1
vote
1answer
20k 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
0answers
282 views

Issue with opening files in Excel Web App SharePoint 2013

I am receiving the below message while trying to open an excel file in a document library in SharePoint 2013. "We're sorry. We can't open the workbook in the browser because it uses these unsupported ...
1
vote
1answer
320 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 ...
2
votes
1answer
4k 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. ...
3
votes
5answers
19k views

Error while opening excel file with “Data validation” feature

When I open a sharepoint Excel file, the error message is: The workbook cannot be opened because it contains the following features that are not supported by Excel in the browser. I know this is a ...
1
vote
0answers
194 views

Can't edit Excel documents in SharePoint 2010 using the webapp - but it is fine using the Excel Client Application

I have a SharePoint site where I can edit excel documents using both the SharePoint web app and the excel application installed on my PC. However, in a new site, I can edit the same excel files using ...
1
vote
0answers
350 views

Unable to filter Excel web access web part

I have an excel web app with a pivot table that's data comes from a powerpivot SQL data source. I am trying to filter this data via basic 'choice web part'. when applying the filter i get an error ...
0
votes
1answer
369 views
1
vote
2answers
528 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 ...
4
votes
5answers
82k 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, ...
1
vote
1answer
129 views

Sharepoint Excel Dynamic dashboard according to a list

I've a list which has something like this: List Title Status Title 1 Active Title 2 Pending Title 3 Active Title 4 Closed I need an Excel BI dashboard which should be dynamically ...
0
votes
1answer
486 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
1answer
18 views

SPO missing EWA in Business Data

Where trying to implement a EWA webpart to a teamsite, but we're missing EWA among other webparts available in the Business Data folder (see pic below)? E3 license - check! SharePoint Server ...
0
votes
1answer
36 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
1answer
60 views

Sharepoint Excel files Capacity Planning

I have requirement to upload 30K records every year in document library and further attach workflow and do some stuff based on business criteria. I need to plan for capacity in SharePoint, so I need ...
0
votes
1answer
369 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, ...