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.
297
questions
1
vote
1answer
4k 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 it ...
1
vote
1answer
1k views
How to delete a row from an Excel Table using the client-side Ewa object in a SharePoint Excel Web Part
The SharePoint Excel Web Part client side API ,Ewa (https://msdn.microsoft.com/en-us/library/office/ee589018.aspx) does not seem to have any methods to manipulate an Excel Table (i.e. a ListObject in ...
1
vote
1answer
29 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 ...
1
vote
1answer
231 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
985 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
2k 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
727 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
338 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
2answers
5k 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
575 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
971 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
324 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
398 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
682 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
763 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
552 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
158 views
sharepoint on premise losing excel changes
SharePoint 2013 on premise is not always saving changes in Excel to the point that some colleagues are losing hours of work. Why does this keep happening?
May I add, that the drafts can be see in ...
1
vote
1answer
875 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
1k 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
33 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
25 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
334 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
135 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
27 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
35 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
210 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
447 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
106 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
4k 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
132 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
889 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
40 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
160 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
201 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
344 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
55 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
219 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
512 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
18 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
86 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
69 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
101 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
44 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
895 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 ...
