Questions tagged [excel-services]

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.

1
vote
1answer
28 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 shall ...
1
vote
1answer
202 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
915 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
1answer
1k 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.
1
vote
1answer
1k 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 ...
1
vote
1answer
572 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
325 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
1k 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 for ...
1
vote
1answer
4k 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
570 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
943 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
5k 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
319 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
6k 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
1k 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
383 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
679 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
1answer
741 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
550 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
344 views

Excel 2010 issue in Sharepoint 2013 - We are sorry we cant open your work book

Can anyone help me with this issue? I am getting an error while opening a excel file in the SP 2013 browser window: "We're sorry. we could not open your workbook. Its possible corrupt or using a ...
1
vote
0answers
539 views

Excel services MSOLAP.8 provider for SSAS OLAP cube

I have an Excel file in SharePoint 2013. This file has an underlying connection to SSAS OLAP cube. However, when trying to open this file using Excel Services, the following error occurs: The ...
1
vote
0answers
30 views

SP2013 + Excel Services .. Help!

I've next scenarios, two server A and B, A is the server of front-end and B is the server of services, We have this in Internet, any users could select the information, this case de users anonymous, ...
1
vote
0answers
21 views

Excel Services PowerPivot - Item Level Permission

I have implemented PowerPivot Chart, PowerView and uploaded the same to PowerPivot gallery on BI Site. Excel Services is configured with "Unattended Service Account" to retrive data from Data Source. ...
1
vote
1answer
217 views

Unable to create or delete Excel service application due to timeout

On my server Excel Calculation Service is "started". I tried to create new Excel Service Application but after some time I get following error. And this is how it looks like after that. If ...
1
vote
0answers
111 views

Field to refresh PowerQuery from SharePoint

I created excel file with power query connections to SharePoint 365 list. then I upload that excel to SharePoint 356. The problem happens when I try open this excel file I get the message: "...
1
vote
0answers
24 views

sharepoint Excel services poor Performanace

I have a excel dashboard in SharePoint 2013 environment that takes for ever ( > 2 min) to open . is there any way anyone can help me in terms of performance tuning this service ? Thanks
1
vote
1answer
26 views

Excel and Visio Unattended Accounts

What are the purposes of the Excel and Visio Unattended Accounts? Both services are used in the farm. I am just interested in knowing why are there dedicated for these? Do they set the application up ...
1
vote
0answers
193 views

Display Excel Sheet Data without configuring Excel Services in Sharepoint

We have configured Office web apps in our SharePoint 2013 environment so now we don't want to configure Excel Services in this environment. Office web apps are working fine we are able to perform the ...
1
vote
2answers
285 views

Access Excel services in Sharepoint Online gives 401

I'm trying to access the rest API of Excel services in SharePoint online from a webjob in C#. I have a client secret and ClientId of an registered add-in and can make Rest request to normal lists and ...
1
vote
0answers
93 views

Copy paste the value from one cell to another based on condition using VBA [closed]

Below are my steps that I need to perform in excel. and I wanted to automate this as & when I run Macro :) Background : I have already imported one sheet from another workbook and recorded the ...
1
vote
0answers
3k views

We couldn’t load the Data Model. This may be because the Data Model in this workbook is damaged

Requirement Criteria I have SharePoint 2013 on premise. I have an excel sheet which loads data from the SharePoint list using listdata.svc service. I am able to load the data into the excel sheet ...
1
vote
1answer
113 views

Unable to open the Excel workbook on SharePoint 2010

I am unable to open the Excel workbooks from our production site in SharePoint 2010. The same Excel file was uploaded to UAT and it is working fine. Please find the fig below for the exact error am ...
1
vote
1answer
741 views

Sharepoint 2013 Excel Services not able to pass parameters to spreadsheet

I'm new to Excel Services. My requirement is to use parameters in the Excel spreadsheet to refresh the data from External data sources. In an Excel spread sheet, I have created an ODBC connection ...
1
vote
1answer
36 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
149 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 If ...
1
vote
1answer
145 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
1answer
339 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
48 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
42 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 ...
1
vote
0answers
203 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
445 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
17 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
74 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
57 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
98 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
43 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 ...
1
vote
0answers
881 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
4k 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 ...
1
vote
0answers
692 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
705 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 ...