0
votes
0answers
10 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 ...
0
votes
1answer
22 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
52 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 ...
0
votes
0answers
17 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
22 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
57 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
17 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
20 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 ...
0
votes
0answers
41 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
241 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. ...
0
votes
0answers
18 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
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
57 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
1answer
61 views

Get-SPExcelServiceApplication Cmdlet not recognized during Powerpivot configuration

I am trying to run the sharepoint powerpivot configuration tool however I am getting a message saying: The term 'Get-SPExcelServiceApplication' is not recognized as the name of a cmdlet, function, ...
0
votes
0answers
24 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
1answer
35 views

Setting to enforce use of Excel Services rather than Excel Web App

Our site and sub-sites are defaulting to Excel Web App rather than Excel Services. We require Excel Services. I think maybe I hit a setting somewhere at the root which has caused this change. Where ...
2
votes
1answer
145 views

External Data Refresh Failed - which setting is causing this error

I'm getting this error message when trying to refresh a workbook. The odc file is saved in the Data Connections library of the sub-site. The excel olap pivot report is saved in a document library of ...
0
votes
0answers
25 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
341 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
1answer
30 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
1answer
54 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
25 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
0answers
39 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
48 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
201 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 ...
0
votes
0answers
23 views

SharePoint 2010 & Excel & Refresh from access databse

I have an excel document that's hosted inside of a SharePoint Server 2010 document library. This particular excel document has a ODBC data connection to an access database, where the access database ...
0
votes
0answers
41 views

Scheduled update of Excel workbook data in SharePoint

We have a number of Excel workbooks that retrieve data from SQL Server. These queries are very intensive, so someone opens each of the workbooks and does a manual refresh each day. Other staff can ...
0
votes
1answer
1k 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 - ...
0
votes
0answers
162 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 ...
1
vote
2answers
7k 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 ...
5
votes
4answers
3k 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 ...
2
votes
0answers
98 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
489 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
1answer
205 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 ...
4
votes
1answer
599 views

How to prevent Excel documents (.xlsx) opening in Excel Services on a mobile device

I have a customer that wants to use the BB(Blackberry) mobile device to open all excel documents (both .xls and .xlsx) using the client application on the device and not excel services. Is this ...
1
vote
1answer
256 views

Unable to use filter or edit Excel Worksheet while opening from Excel web access?

I am able to view and filter data based off excel fileters via the Excel Web Access web part for Excel workbooks. However, when I "open in Excel" it does not allow me to filter or edit. Note: I ...
0
votes
1answer
1k views

Getting rid of the session timeout in Excel Web Access?

I understand there is a 30 second short session timeout (if no interaction is detected) to a 5 minute extended sessiopn timeout. The userss would like their reports up all day, just refreshing every ...
1
vote
1answer
195 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. ...
0
votes
1answer
589 views

Excel Service Application - SharePoint 2010 (Performance Management)

I have a SharePoint 2010 farm with three servers :- Server 1 - WFE Server 2 - CA + WFE Server 3 - DB Cluster + WFE I have Excel Calculation Services Started on all the servers.These are my ...
0
votes
2answers
1k views

How to customize SharePoint Chart web part

I want to customize SharePoint chart web part programmatically to display charts from the excel sheet having different charts on different sheets of the excel. How can I customize chart web part so ...
1
vote
2answers
3k views

SharePoint 2010 Co-Authoring Excel

Are there any other settings, besides disabling "Check Out", to enable Co-Authoring in Excel? When I open Excel, all I get are the options in the image I attached. I do not get the "Edit" option ...
1
vote
3answers
4k views

EXcel Web Access - web part Error

I asked this related question in stack overflow, Hence this forum is dedicated for sharepoint, Thought to ask here!! I got to know how to get the Excel using sharepoint Excel web access webpart. ...