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

3
votes
2answers
3k 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
2answers
156 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 ...
7
votes
1answer
231 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 ...
3
votes
1answer
3k 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
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
1
vote
1answer
37 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 ...
1
vote
1answer
109 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 ...
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
1answer
348 views

Since last patch, unable to open excel documents and word documents can only be opened by dropdown

We performed updates to the SharePoint Portal, SharePoint Foundation, Office Sharepoint Server, Excel Services Component, and Word Server on 03/16/2014. Since then, we are unable to open Excel ...
1
vote
1answer
906 views

Why does SharePoint 2010 Excel WebPart not find Excel spreadsheet in Share Documents?

I have a SharePoint 2010 single instance. The Web site has an Excel worksheet in Shared Documents, which I can navigate to as a user. I have enabled Excel services. I have activated Excel services ...
1
vote
1answer
2k views

Not able to refresh External data in Excel Sharepoint 2010

I am not able to refresh the data in Excel when see the excel report in browser. When i press Refresh All options the page get refresh but no updation in data is reflected. Actually i have two ...
1
vote
1answer
321 views

issue with Excel Services in SP2010

I have created a Excel and enabled the connection to external sQL database through Secure store service and created the odc file . When i open the excel in sharepoint it refreshes the data and it is ...
1
vote
1answer
51 views

Excel Services User Defined Function returns #NAME?

I've followed all the steps as described in numerous blog posts, including the MSDN Walkthrough, on setting up User Defined Functions in Excel Services. However, I'm still getting "#NAME?" in the ...
0
votes
1answer
53 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 ...
0
votes
1answer
275 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 ...
0
votes
1answer
205 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.
0
votes
1answer
334 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
17 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
269 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, ...
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
315 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
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; ...
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 ...
0
votes
1answer
132 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
1answer
284 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,
0
votes
1answer
507 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 ...
0
votes
1answer
167 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
1answer
167 views

Read from an excel Sheet and write to a List

My requirement is that, i need to upload data from an excel sheet to an existing sharepoint List in SP 2010.I will have 2 different Lists Like this. Then I need to compare Both the List and retrieve ...
0
votes
0answers
20 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
0answers
34 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 ...
0
votes
0answers
104 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 ...
0
votes
0answers
50 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 ...
0
votes
0answers
46 views

Prevent “We're opening your workbook in Microsof Excel” message from being displayed

I have multiple environments with SharePoint solutions installed on them. Almost all of them are working fine except one that has an issue and don't know how to solve it. Each time I open an Excel ...
0
votes
0answers
50 views

Can we get Excel Pivot chart as an image in SharePoint 2013

I have a workbook which has a pivot chart and we are showing it in Excel services web part. Now my question is: Is it possible to access that chart (as an image) element? I know we can use REST api ...
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
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--> ...
0
votes
0answers
317 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 ...
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 ...
0
votes
0answers
37 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
236 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
276 views

SharePoint 2010 List Excel Export Error

I have some problems about exporting a SharePoint List to excel. I'm getting "Excel cannot connect to the SharePoint list" error while exporting it to excel. There wasn't any error in the same list ...
0
votes
0answers
296 views

Excel webpart limitations…?

Excel webpart limitations? Wanted to configure 8 Excel webparts on my SharePoint 2010 page, it works for 5-6 Excel webpart on the page and started throwing the error "Internet Explorer cannot display ...