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
1k views

SharePoint Online & Excel Services -> unable to refresh data connections

I'm trying to create a few very simple reports based on my SharePoint Online data using Excel. I've got as far as getting the data into Excel and creating my report, and now I'm trying to upload the ...
2
votes
0answers
55 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
100 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
394 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: ...
1
vote
0answers
382 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. ...
1
vote
0answers
237 views

Issue with Office Web Apps - can't open Excel file, prompt for user name and password

I can't open by Office Web Apps Excel file, SharePoint always prompt for user name and password and after entering correct user name and password it happens again and get error: "An error has ...
1
vote
0answers
47 views

How can I remove Excel menu in web apps in Share Point 2013?

I use SharePoint 2013 and I use Power Pivot Service. When I open an Excel Report, I see this report : How can I remove Excel menu(File/Open In Excel / Data/...) from this report?
1
vote
0answers
42 views

Excel Services permissions error

I have created a document library, and gotten that library added to the Excel Services Trusted Locations in central admin. I’m using an account which has full control on the document library to ...
1
vote
0answers
685 views

An error occurred while loading the model for the item or data source 'EntityDataSource'

I use SQL Server 2012 SP1 U8 and SharePoint 2013. I configure Excel Service and Performance Point Service and PowerPivot Service. I create an Excel File`that fetch data from Data Warehouse in ...
1
vote
0answers
95 views

Hyperlink to force Excel to open in Excel Services

We have found that a link, like the following, pasted into an Outlook email will always open the target file in the users local copy of Excel: <http://ourspbi/myreports/Some Excel report ...
1
vote
0answers
21 views

Make First Sheet Display in Excel of Sharepoint in Browser

I have a Excel Web part and make an excel appear in browser throught this web part. There is 4 sheets in excel but when I open the page , firstly the third sheet appears but not he first sheet. How ...
1
vote
0answers
155 views

SP2103 Excel-Services Freeze Panes / Headers

Do anyone know a simple solution to freezing the headers in an Excel file that is published on a SharePoint 2013 portal.
1
vote
0answers
157 views

Enable Publishing Options button without SharePoint Designer

We use MS Office 2010 Standard, and some users will be publishing spreadsheets from Excel to SharePoint (2010). We have discovered, however, that the Publishing Options button only appears in the Send ...
1
vote
0answers
325 views

Excel Web Access Web Part won't display workbook

We've recently upgraded from SharePoint 2007 to 2010 and we are trying to get the Excel Web Access web part to work. Excel Services is running if that's required, the workbook location is configured ...
1
vote
0answers
126 views

Adding Excel Reports / TFS Web Part to My Site

I'm using Sharepoint 2013 and would like to add some Excel Reports to "My Site" but I don't know where to begin. Excel Services have been configured correctly since we also have the team foundation ...
1
vote
0answers
56 views

Missing rows in PerformancePoint Dashboard chart compared to Excel Services

Excel which is published has more than 75 rows but in dashboard there are only 75 rows for the report.Are there any parameters are set for this in dashboard designer or any other changes are required. ...
1
vote
0answers
49 views

Fact tables indicators selectors/filters in an excel report with pivot tables

I'm working in a project where I need to publish some reports based on excel pivot tables against SSAS cube. Until here everything is OK. However, I want to know how I can set in my excel report a ...
1
vote
0answers
224 views

Value error in UDF with Excel Services

I've written some C# User Defined Functions for Excel that I'm trying to run in Excel Services. One of these UDFs is working in my local environment, but failing in the QA environment. Instead of ...
1
vote
0answers
420 views

Customize toolbar in xlviewer.aspx

We would like to replace the "Open in Excel" button with the "Download a snapshot" command in the xlviewer.aspx file. Is this something you can configure when using this file to view documents? I ...
1
vote
0answers
40 views

How to add EWA parts with the non-enterprise version

Is it possible to add a Excel Web Access part to a dashboard in the non-enterprise version? If not, is there another way to simulate such a dashboard?
1
vote
0answers
61 views

Can Formulas Automatically Update in Excel Services 2007?

I currently have two spreadsheets housed in Excel Services in a Sharepoint Hub. These two spreadsheets are linked. However, the values on my main spreadsheet will only update 1. if the source ...
0
votes
0answers
14 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
13 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
13 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
22 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
0answers
24 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
0answers
44 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
0answers
50 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
19 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
38 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
73 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 ...
0
votes
0answers
87 views

Sharepoint 2013 Errors 6309(timer) & 8059(Claims Authentication) Excel Web App Error

The issues I am getting is a 8059 error "and exception occurred when trying to issue security token" it then asks me to turn on "includeexceptiondetailsinfaults" whichIi try to do on the security ...
0
votes
0answers
18 views

CUBEFUNCTIONS failing in Excel Services but ok in Excel

I'm encountering a problem whereby we have Excel reports that are saved on our SharePoint server: when opened in Excel Services they show #N/A. if I then hit the button OPEN IN EXCEL the formulas ...
0
votes
0answers
42 views

Excel cannot connect to the SharePoint list

I'm getting this error while exporting a custom list to excel. Any ideas why I'm getting this error? Here is the same question. Still couldn't solve this error. P.S.: "Check for server certificate ...
0
votes
0answers
19 views

Excel services 2010 how to clear cell value

I am trying to interact with an Excel file in a SharePoint library.The Excel work book is always present at the library. When I do an upload of Excel the cells get appended to the existing file in ...
0
votes
0answers
36 views

Save/Edit Excel workbook from Infopath form

I have an Excel workbook with a chart in it. This workbook is for a research. When a new research starts, the user creates a new workbook (based on a template) and saves it (with associated data). I ...
0
votes
0answers
170 views

Excel Online - refresh data in a SharePoint list

I have added a SharePoint list to an excel spreadsheet as an odata feed. This data connection refreshes perfectly using Excel on the Desktop. However, when I refresh the connection in the Excel web ...
0
votes
0answers
65 views

Excel rest request in C# gives unauthorised exception

I'm trying to call an Excel rest request through my C# console program. the problem is that every time I put in my login details in the console and the request is sent. I get an unauthorized exception ...
0
votes
0answers
8 views

Excel Services transparent similar to Reporting Services

When using the Reporting Services web part we have found that we can make the background of the report transparent so that what ever back ground is used in Sharepoint will show through the table. Is ...
0
votes
0answers
71 views

Can I toggle Named item in one Excel Web Access web part via a filter web part

I have two charts that are named as follows in one workbook: ChartX (line chart of revenue) ChartY (bar chart of happiness) The workbook has been uploaded to our Sharepoint sub-site. In a web ...
0
votes
0answers
44 views

SharePoint 2013 - XLViewer

Is it possible to customize the XLViewer in SharePoint 2013 out of the box? By out of the box, you can find options in, say, Central Administration to modify the access rights such as allowing the ...
0
votes
0answers
27 views

Can I suppress Excel Services alert “Query and refresh Data”

We have a sub-site with a doc library "Reporting". Saved there we have several xlsx files. Within the same sub-site we have a Data Connections library with odc' files linking through toOLAP` cubes. ...
0
votes
0answers
28 views

Uninstall/reinstall PowerPivot

I am thinking I need to unintall/reinstall PowerPivot on my SP 2013 (single-server) farm, due to the fact that I mistakenly installed it when I had the wrong version of Analysis Services installed on ...
0
votes
0answers
400 views

PowerPivot Management Dashboard: Workbooks do not update in Excel Services

[Running SP 2013 Enterprise SP1 w/ SQL Server 2012 SP1] I having a couple problems with the PowerPivot Management Dashboard. (Well, maybe more than a couple but I am focusing on these right now.) If ...
0
votes
0answers
24 views

SP2013 - Calculate a coaching Score from a sharepoint list

Scenario : We use a sharepoint list with a custom InfoPath form to Quality Coach our colleagues. The list itself is a series of questions with Yes (Y) , No (N) and Not Applicable (X) as options. We ...
0
votes
0answers
54 views

File Access Method setting under Excel Service settings in SharePoint

Under Excel Service settings in SharePoint, File Access Method (The authentication method used by Excel Calculation Services to retrieve workbook files from all non-Microsoft SharePoint Foundation ...
0
votes
0answers
53 views

EffectiveUserName for Excel Services in SharePoint 2013 not working as expected

I have followed the steps mentioned under this MSDN article. Under Roles for SSAS DB, I have added only User A and User B, not User C. My SharePoint site has 3 users under the Site Owners. --> User ...
0
votes
0answers
44 views

Is it possible to edit excel file on SharePoint online from iOS app?

Currently, I am developing an iPad app which can manipulate excel file that is stored on SharePoint online service. I am able to retrieve data from excel file using Excel Services REST API, but when ...
0
votes
0answers
30 views

Duplicate menu in excel report in performance point service of share point 2013?

I use SharePoint 2013 and Performance Point Service. I change menu my menu in my Master Page file with one static menu. <div style="width:550px;background- ...
0
votes
0answers
219 views

Sharepoint 2013 Excel Web Access Web Part- display workbook's worksheet data per web part

I am trying to display data via the SP 2013 Excel web access web part and a workbook generated by BI360's excel plugin.The challenge is that as it's a new workbook each monthly reporting period, I ...