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
47 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 ...
3
votes
2answers
2k views

Remove HTML Tags from the SharePoint List column value?

We were trying to create a SharePoint List based on a spreadsheet, a few columns in the spreadsheet has bulleting/numbering. SharePoint List is updated with the details from the Excel, however it ...
0
votes
1answer
41 views

What is the purpose of User-Defined Functions under Excel Service Application?

I have done a lot of research and have concluded that we cannot use VBA present under Excel sheet code in SharePoint. Today I was reading on excel services in sharepoint. I came across User-defined ...
0
votes
1answer
78 views

How to programatically modify contents of an excel sheet via excel web services in SharePoint 2013?

I have read that, While users can interact with Excel workbooks in a browser through Excel Services, the workbooks cannot be edited in the browser by using Excel Services. Programmatic options are ...
0
votes
1answer
44 views

What is the purpose of Allow External Data Under Excel Service Application --> External Data?

We have a excel book that we can open via excel web part on sharepoint page. The excel book has external data connection to SQL Analysis server. Presently the setting for Allow External Data is set ...
0
votes
0answers
77 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
86 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 ...
1
vote
0answers
136 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 ...
0
votes
2answers
1k views

Import File from SharePoint and Link this file with SharePoint (File- Excel File)

I am using SharePoint 2013 and Microsoft Office 2007 or above. Scenario: I upload a Excel file to a SharePoint 2013 list. Now, I want to import this Excel file from this SharePoint list back to ...
0
votes
1answer
247 views

Power View Report in Excel dont work in Share Point 2013 web site

I use Share Point 2013 and SQL Server 2008 R2 and Performance Point Service and I use Excel Service for show Excel Report in SharePoint 2013 web site. My SharePoint web site work and I can view Excel ...
0
votes
0answers
61 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
37 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- ...
1
vote
1answer
111 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
934 views

Convert the Infopath Form into PDF or Excel in SharePoint 2010?

We have designed an Infopath Form and published as a document template on a library. Now, we would like to add a feature to export the InfoPath Form details to Excel or publish the InfoPath Form as ...
1
vote
1answer
4k views

Excel error in sharepoint

I tried to open this Excel worksheet in Sharepoint and got the following message. The Window cannot be opened because it contains the following features that are not supported by Excel in the ...
0
votes
0answers
275 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 ...
1
vote
1answer
785 views

Thumbnails/snapshots don't show in PowerPivot Gallery when the document refreshes on open

I have several excel documents containing PowerPivot tables. They all connect to a SSAS Tabular service (on SQL 2012) via a .odc connection file, all of which is hosted on SharePoint 2013, using the ...
1
vote
0answers
407 views

Problem connecting Sharepoint 2010 to SSAS through a RSDS

As the title says, I'm trying to create a Report Data Source on Sharepoint 2010 where I have an SQL2012 instance with the PowerPivot, SSRS and the sharepoint add-in configured. I choose "Microsoft ...
1
vote
0answers
24 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 ...
2
votes
1answer
46 views

Can people play with fields using PowerPivot?

I began on a BI job a few months ago and one of my first tasks is to replace our current way to access the SSAS cubes. It is a custom web application based on OWC (which is now deprecated) and it's ...
2
votes
3answers
17k views

Disable Excel Web Access?

Is there a way to disable Excel Web Access (_layouts/xlviewer.aspx) completely on a Site Collection? (SP2010 Enterprise) I have enabled the "Open in Client Applications" feature and it works fine in ...
0
votes
1answer
1k views

Event Attachments Opens Excel Spreadsheets in XLViewer

I have a calendar list with attachments enabled. When i attach an XLS file to an event, SharePoint wants to open it in xlviewer.aspx, but throws an error every time. I don't want to open the file in a ...
0
votes
1answer
72 views

Is it possible to specify content database name while creating the Excel Service Application using powershell script?

I want to create the Excel Service Application as it is required to use the Excel Web Access Web Part. Firs I tried to create the application using sharepoint but GUI not providing facility to specify ...
0
votes
1answer
1k views

Access was denied by the external data source. The following connections failed to refresh: “data connection name”

I created a Excel report in Excel 2013 with a data-source as SQL stored procedure. I deployed this Excel report to Trusted Excel Library. I have done all configurations correctly in Excel Service ...
0
votes
1answer
79 views

How to use SharePoint 2010 web chart to create a chart with 3 columns, I met 2 problems, can you help me?

This is my Excel file, with 3 columns Date Ongoing Pending 4/22/2013 4 4 5/22/2013 4 4 6/23/2013 4 4 6/24/2013 4 4 6/25/2013 4 4 ...
1
vote
2answers
10k views

Excel Services Error in SharePoint 2013 - Unable to Open/Edit Excel Files

Every time I click on a excel file I am receiving a popup message mentioning - We're sorry. We ran into a problem completing your request MS Word is working fine though. I performed all the ...
2
votes
0answers
61 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 ...
1
vote
1answer
217 views

Is it possible to read an excel file through code in a sandbox solution - SharePoint Online

On a SharePoint Online environment, I have an Infopath based list with Attachment enabled. When an excel file is attached during a new item creation on this list, I want to have an event receiver that ...
0
votes
0answers
984 views

Export Excel Table to Sharepoint List throwing publishing error?

I have a SP Foundation 2010 installation on windows 7. I created a OOTB Contacts list in SharePoint and tried exporting an excel (Office 365) table with various fields to this list. Note: The column ...
3
votes
4answers
16k views

possible ways to import an excel spreadsheet to a sharepoint 2010 list?

I am running SharePoint Server 2010 and I have an excel spreadsheet of about 3000 rows / 30 columns, which I would like to import to a SharePoint list. I've seen on codeplex a free tool for MOSS/wss ...
0
votes
1answer
125 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
1answer
313 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 ...
1
vote
0answers
207 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
212 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 ...
0
votes
1answer
2k views

Excel services and PowerPivot error: “Unable to refresh data for a data connection in the Workbook. ”

My environment is a 3-tier SharePoint 2010 Architecture: Running on SQL Server 2012 Enterprise Edition WF1 WF2 Both Web Fronts are NLB, and we have they following Application Servers APP1 - ...
5
votes
4answers
4k views

How to setup Kerberos Constrained Delegation for SharePoint Excel Services and Analysis Services

This question is in continuation to MSOLAPSvc.3 service missing from kerberos delegation Target : To refresh a pivot table based out of a SSAS cube using Windows Authentication in the excel service ...
0
votes
1answer
136 views

Excel Calculation Services - Excel Web Apps

We're trying to co-author excel workbooks but only have Standard CAL/Sharepoint 2010 Standard Server license. Its my research so far that to have co-authoring for Excel, we would need to use Excel ...
0
votes
0answers
186 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
1answer
177 views

Implementation of power view in sp 2013 - Pain Points and Ideas

Can anybody please give me some painpoints of using PowerView in sharepoint 2013. Recently in our project we are planning to upgrade our site from SP2010 to 2013. In SP2010 site we have lots of ...
0
votes
1answer
39 views

Regarding excel service in sharepoint 2010

We planning to purchase Sharepoint 2010 standard version. I notice SharePoint 2010 standard version does not support Excel service. My question is, am still able to load the excel document in ...
1
vote
1answer
706 views

Powerpivot data refresh over kerberos delegation

I have a SQL 2008 R2 OLAP Cube and an Excel file that uses powerpivot and embedded datasource to the Cube. I want to upload the Excel file in SharePoint and allow users who are authenticated to the ...
1
vote
0answers
60 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
1answer
736 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
0answers
160 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 ...
2
votes
0answers
518 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: ...
2
votes
0answers
108 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 ...
1
vote
1answer
66 views

How to collect data from many users

In our company from time to time there are polls (like 'Name, Employee number, Will you attend the christmas party? Dinner preference?' ... ) which are typically handled via Excel sheets shared in a ...
0
votes
1answer
347 views

How to convert Sharepoint 2010 Chart web part to Excel?

I want to convert chart webpart's chart to excel format how it is possible?
1
vote
1answer
2k 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 ...
0
votes
6answers
532 views

Test drive of PerformancePoint and SSRS on SharePoint

I need to build advanced reports on SharePoint, where radars, pivots and cumulative values are involved. One obvious option is Excel Services, but I'd be interested to compare it with PerformancePoint ...