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
0answers
43 views

Open In Excel Issue

I have two sites on SharePoint2013. I used excel webpart. I worked these sites in IE 11. "Open In Excel" works a site, but doesn't work other site. What is the cause of this problem?
1
vote
0answers
65 views

Workflow Tasks data in Pivot Chart

Has anybody ever tried to create a pivot chart in Excel based upon the workflow tasks list in SharePoint? One of my users is requesting a chart showing all users associated with active or completed ...
0
votes
0answers
46 views

Excel Web Access Content Visible to User Which are not exist in Excel Slicer (Used Current User Filter)

I have used Current User Filter in Excel Web Access Sharepoint 2013. I have used Excel 2013 Data imported from Database. If Current Login User not found in Slicer then Excel Web Access shows Error ...
0
votes
1answer
15 views

Offline doc linking to sharepoint doc (specifically excel)?

I searched for an answer to this and the various answers left me confused, so I figured I'd come here now since I always get a reliable answer from this forum. I have Office365 and I use Excel Online ...
0
votes
1answer
314 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 ...
0
votes
2answers
171 views

Customize xlviewer.aspx in SharePoint 2010?

We're using SharePoint 2010 and I have a requirement to hide the breadcrumb links at the top of the xlviewer.aspx page for Excel Services. I've found quite a bit of documentation on how to customize ...
2
votes
1answer
128 views

Excel Web App dropdown control issues

Happy New Year everyone, I am having some strange issues with our on-prem SharePoint 2013 environment. When a user opens an excel document in Excel Web App in IE, the dropdown controls (edit ...
1
vote
0answers
139 views

Excel Service Data Refresh Issue in SharePoint 2013 Online Office 365

I am using Excel Services in Office 365 SharePoint Online to show Workbook Pivot Reports data pulled from SQL Server 2008. I have used Secure Store for saving Database Credentials & Configure ...
1
vote
0answers
61 views

Sending parameter to excel web access charts

I have some pivot charts displayed using excel web access, all of the charts have some filters, I would like to create a common filters to interact with excel web access charts. Is there a way I can ...
0
votes
0answers
115 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--> ...
1
vote
0answers
960 views

When I try to view Excel in browser I got error We don't know what happened, but something went wrong

When I try to view Excel in browser I got error We don't know what happened, but something went wrong. When I try to edit file is ok? In event log I get: There was an error in communicating with ...
1
vote
1answer
1k views

How to connect an Excel file to a Data Connection Library?

In the article here, it states that an excel file can connect to a .odc file inside a DCL. I've researched for a bit and finally stumbled upon a solution that involves having to modify registry ...
0
votes
0answers
315 views

Restore Errors on Sharepoint

I got up backup a server. And I want to restore the backup to nother server. But I got this error and my restore job is failed. Object Excel Service Application failed in event OnRestore. For ...
2
votes
1answer
1k views

External Data Refresh failed - Unable to refresh list data in Excel Web Access WebPart

I have created a PivotChart in Excel workbook that fetches data from a SharePoint list using "OData Data Feed". When refreshing the connection in Excel 2013, the updated data is displayed in ...
2
votes
1answer
1k views

“Open in Visio ” & “Open in Excel” is not working, and I will get an error message

I have the following inside my SharePoint server 2013 :- EnterPrise Wiki site collection. i have both "Excel services Application "& "Visio Graphics Service" running correctly. The problem i ...
0
votes
1answer
40 views

I need help - some excel docs not opening in sharepoint

Many excel files in our libraries are no longer able to be opened. They can be downloaded via the drop down menu, but will not open with a click as they should be. The pop-up message we get is; ...
1
vote
1answer
246 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 ...
0
votes
1answer
35 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 ...
2
votes
2answers
401 views

Cross domain issues accessing Excel Services in a Sharepoint App

I have an Sharepoint app hosted at: https://app-xxxxxxxx.sharepoint.com/sites/my-site/ And I want to retrieve the json representation of an excel document using the Excel Service Rest API hosted ...
1
vote
2answers
155 views

Excel web service web part in sharepoint 2013 app

Is it possible to add Excel service web part in SharePoint 2013 app? My intention is to create dashboard with graphs and charts (from excel which was published) in the app. Please help me with any ...
1
vote
0answers
37 views

Excel Workbook webpart filtering display issue

Has any one experienced an issue with Excel workbook WepPart not displaying the filtering box and items? What it does look like: What it should look like: This is not displayed until I select ...
1
vote
1answer
1k 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 ...
7
votes
1answer
230 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 ...
0
votes
1answer
131 views

How to exctract filtered items from SharePoint List to Excel

I'm using Javascript and AngularJS to get all data from a SharePoint list in JSON and displayed it into a table. User can sort it, filtered it and etc. There is a really nice paggination. Everything ...
0
votes
2answers
2k 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 ...
0
votes
1answer
283 views

Move BI Center (Excel, PerformancePoint, PowerPivot) to other SQL server - SharePoint 2013

What way would be the best to move BI Center to other SQL server in SharePoint 2013? Thanks,
1
vote
1answer
1k views

Cant open excel workbooks in browser sharepoint 2010

Okai I am currently facing an error when i try to open excel files in browser . it gives the prompt "The workbook can not be opened". Upon checking the logs I found the following entries in the log ...
1
vote
0answers
96 views

Excel data doesn't appear, in the Excel Web Access

I've added an Excel Web part into my page. I did check out this excel workbook. But, when I want to run my page , I'm getting as follows error. Also,when I want to open xslx file in my desktop, the ...
0
votes
1answer
45 views

How to add new service application with Central Adminstration

I want to excel document into my webpart in sharepoint 2013. First, I added a webpart in my page as follows. Then I clicked "Click here to open the tool pane." and I added workbook URL and OK. But ...
0
votes
2answers
915 views

Excel Services REST API returns 401 Unauthorized in Workflow

I am trying to make a call to the Excel Services REST API in a workflow to retrieve information on a workbook's charts. The URL format is ...
0
votes
0answers
103 views

Update Excel document without checking in and checking out

Suppose we upload a shared Excel document in the SharePoint 2013. If we try to edit it allows to edit for a windows user and allows to save it. If then another windows user tries to edit the same ...
0
votes
0answers
54 views

Excel Web access webpart url

I am following an Article to solve a "The Workbook cannot be opened" that appears on my webpart when I load the document. It mentions getting the url of the webpart, in order to complete a powershell ...
2
votes
0answers
14 views

Poll app 2010 producing graph [closed]

I am creating a poll app in 2010 just wondering what the best way would be to produce a graph would be. would I be able to do it using excel
0
votes
1answer
503 views

How to access Excel PROTECTED spreadsheet in SharePoint Web Access Web Part in SharePoint2013?

I have excel file which is protected by password. I need to access Sheet 1 on SharePoint Web Part Page on Dashboard. While I add protected I can not able to Excel Sheet is corrupted as per below ...
1
vote
1answer
2k views

Power Pivot and Power View do not work for Excel workbook with external connection

I have SharePoint 2013 with Power Pivot and Power View. It's based on SQL Server 2012. They seem to be configured properly as they work fine with Excel 2010 workbook that contains tabular model that ...
2
votes
1answer
356 views

Convert Single line of Text to Lookup type after importing data from Excel file

I imported the data from excel file, but some column data type I need to change from single line of text to Lookup value. How to do this? I am using SharePoint 2013
3
votes
1answer
33 views

Reusable Tasks - moving an process from excel workbooks to SharePoint

My team use a SharePoint 2013 team site. Currently when we deliver training we use an excel workbook which tracks student names, and tracks their scores and has a standard task list of content that ...
2
votes
0answers
114 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: ...
1
vote
1answer
125 views

SharePoint 2010 Multi Tenant - I need Excel Services

We are running SP in Multi-Tenant mode for a few small clients. I need Excel services enabled for two of the tenants. What options do I have and how do I do it? I have been looking at documentation ...
1
vote
5answers
19k 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 ...
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 ...
0
votes
1answer
957 views

Reading excel cell value in Excel Web Access Webpart

I need to read excel cell value.Excel web access webpart is used to display excel file stored in a SharePoint 2013 document library.I need to use Jquery to read the data of excel file currently ...
2
votes
2answers
624 views

Refreshed SharePoint 2013 charts

I'm trying to understand what would be the best way to display up to date/real time data coming from a SharePoint List in a chart, if it's possible at all. Why? Today I was quite surprised to learn ...
0
votes
1answer
166 views

Sharepoint Excel Logic

I have an Excel spreadsheet that I would like to import onto Sharepoint. The import/export function is easy enough to use, however the math logic that four of the cells conduct in the Excel ...
0
votes
2answers
241 views

How to know if Excel Services is available on SharePoint?

I'm using a Sharepoint 2010 server. Unfortunately, I'm not the administrator and I'm not able to connect with him. But I want to know, if Excel Services is installed and activated. I'm able to edit ...
1
vote
1answer
754 views

How to use excel services REST api in Sharepoint Hosted App

I need to call excel service rest api as follows on the 'Summary' library in hostweb ...
0
votes
0answers
36 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
23 views

SharePoint 2010 Workbook cannot be open in Chrome [duplicate]

The Workbook cannot be opened because it contains the following features that are not supported by excel i n the browser: Data validation Sheet Protection I'm trying to open excel document in ...
3
votes
3answers
8k views

How to create an auto-updating chart from a Sharepoint list

Is there a way to create a chart/graph from a Sharepoint list, whether through Sharepoint graphing or MS Excel, so that the chart will automatically update when the data in the list changes? I've ...
4
votes
2answers
2k views

Retrieving list items from multiple sites via OData with Excel

I want to build a report: with Excel 2013 + PowerPivot Add-In using data from SharePoint Online that should work in Excel Services (so I'm not able to use VB, Power Query, etc.) Report should be ...