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

6
votes
5answers
18k views

Unable to open office files in Office client

While trying to open an excel document stored in "Shared Documents" library, the excel application opens up with a login prompt, to which I passed the login credentials of the site. After which the ...
6
votes
1answer
712 views

How can I set the relative path to a workbook in the Chart Web Part, and use it within a template?

We have a team site in our solution (SPS 2010 - Enterprise). On this site there's a list. For every new item in the list, it creates a new site from a template. Structure: team-website website 1 ...
4
votes
4answers
2k 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 ...
4
votes
4answers
2k views

Excel Services - Using parameter for query

I have an excel spreadsheet that returns data based on a cell value. In essence, it's Select * from table where field = Sheet2!A1. All works like expected, except when I publish it to SharePoint, ...
4
votes
1answer
508 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 ...
4
votes
2answers
350 views

Sharepoint deployment scenario with absolute urls involved

I currently have dozens of Excel workbooks being displayed in Excel services on our development Sharepoint server. The workbooks are setup to use an .ODC connection file which is hosted in a trusted ...
3
votes
7answers
18k views

Excel Services 2010 Error - “The workbook cannot be opened.”

I enabled Excel Services and added a Excel Web Access viewer to my page. It's just a simple spreadsheet (which incidentally works fine on my standalone development server) that displays the error ...
3
votes
4answers
14k 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 ...
3
votes
2answers
294 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 ...
3
votes
2answers
7k views

Setting up SharePoint 2010 Excel Services

How do you set up Excel Services for SharePoint 2010? I’ve installed the Office Web Apps (wcsetup.exe) and created a new Excel service in central administration. But I’m now stuck on what to do ...
3
votes
2answers
6k views

how to reload worksheet displayed in excel web access webpart

I have an XSLX file in a SP 2010 document library. I use the excel web access webpart to display it in a web page. However, if I modify the file, the changes are not immediately visible on the page. I ...
3
votes
2answers
1k views

Disable “Open in Excel” in Excel Services on SharePoint 2010

I would like to disable or remove the ability for users to use the "Open in Excel" button and only allow the "Edit in Browser" button. Can this be done through security settings and/or user groups? ...
3
votes
1answer
106 views

Excel web access data ( graphs) is showing gray color on SharePoint 2007

I am using "Excel Web Access" Web Parts to show the excel graphs in my MOSS2007 setup. I have multiple team sites under one site-collection. Excel web access is fine for all the team sites but , its ...
3
votes
1answer
218 views

How to configure Excel and SharePoint to access remote databases

I am using Excel to render data stored in a PostgresQL database elsewhere on our network. In general, the rendering works. However, I haven't been able to get the document to automatically ...
3
votes
2answers
871 views

Can Excel Services 2010 query SharePoint lists directly?

A problem with SharePoint 2007 Excel Services was that it could not query SharePoint lists. Does SharePoint 2010 now contain this functionality?
2
votes
2answers
475 views

Be careful. The query to get the data might be unsafe so you should only refresh the workbook if you trust its source

I use SharePoint 2013 and Excel Services and SSAS I load an Excel file to SharePoint Document and then I use that in Performance Point Service to create an Excel Report. I then use this report to a ...
2
votes
3answers
9k views

Excel document opening in browser (unsupported features)

I am using Sharepoint 2010 and when users click on an .xlsx document in a document library it says the following: "The workbook cannot be opened because it contains the following features that are ...
2
votes
2answers
106 views

Crunching numbers according to user-defined formulas: best approach?

I have been trying different solutions to this problem, including a completely custom data processing module; now I feel like I've run out of options and was wondering what people thought was the best ...
2
votes
3answers
15k 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 ...
2
votes
3answers
622 views

MOSS 2007 Excel Services Webpart Formatting

Is there an easy way (i.e without programming & deploying a custom webpart) to remove the column/row headers in an Excel webpart view on a MOSS 2007 site? Customer sees: A B C ...
2
votes
1answer
49 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 ...
2
votes
1answer
38 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
4answers
6k views

Error while opening excel file with “Data validation” feature

When I open a sharepoint Excel file, the error message is: The workbook cannot be opened because it contains the following features that are not supported by Excel in the browser. I know this is a ...
2
votes
2answers
2k views

PerformancePoint Dashboard Designer - New Excel Services data source

I'm trying to connect a published Excel workbook as a data source in PerformancePoint Designer, but I'm unable to do so. Here's what I'm doing: In PPDD, on the Create tab, I click Data Source. I pick ...
2
votes
1answer
2k views

Excel Services Refreshing data for Pivot Table bound to SharePoint 2010 List

I've noticed that while Excel Services does support quite a few OLE DB and ODBC connectors, to e.g. SQL server, OLAP, Oracle and so forth, there's no direct connector for SharePoint lists. ...
2
votes
2answers
94 views

SharePoint 2007 Excel Services - Security implications of adding root as a trusted location

I've done some searching and can't find a definitive answer. In a large SharePoint environment where it'll become a hassle to add individual trusted locations for Excel Workbooks, is adding the root ...
2
votes
0answers
558 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
804 views

Cannot create a PowerPivot data connection (PerformancePoint Services in SharePoint Server 2013)

I can create data sources that connect to SQL Analysis Servier 2012 instances, but not to the PowerPivot instance. I followed the instructions here: ...
2
votes
0answers
47 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
1answer
1k views

Error while opening sharepoint list in datasheetview and exporting to excel

I have a List which is having around 14000 items in it.while opening that list in datasheet view it is giving error . Below is a summary of the issue: After selecting datasheet view : "Cannot ...
2
votes
0answers
84 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
247 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
1answer
655 views

Issue with Excel Services work book with Integrated Security but logged in from Claims auth

I am trying to use an embedded Excel work book within a SharePoint site. This workbook connects to SSAS using Integrated Security. It works correctly when I log in to SharePoint using windows ...
1
vote
3answers
3k 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. ...
1
vote
2answers
2k 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
1answer
118 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
400 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 ...
1
vote
1answer
198 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
2answers
6k 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 ...
1
vote
1answer
61 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 ...
1
vote
2answers
550 views

Can a C# web service access an Excel Services workbook?

A bit of background: I have an InfoPath browser form that I have connected to a C# web service that I've written. I have an Excel Services worksheet published in SharePoint as well. What I'd like to ...
1
vote
1answer
1k views

Sharepoint foundation-Need to show excel file contens within sharepoint page

Scenario: Sharepoint foundation 2010. End users would like to view the EXCEL documents within sharepoint page and not loosing the typical excel functionality. The USERS would open EXCEL file (using ...
1
vote
2answers
175 views

Parsing Excel doc in SharePoint

In my current project I have requirement to upload an excel file, parse it and send the data to a third party system. I have no need to persist the file either in SharePoint or on disk and I don't ...
1
vote
1answer
42 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
197 views

If a user can't read Excel file, can they still view Chart Web Part created from it?

Title sums it up. I would just try it myself but my test environment is down and I figured I might get a speedier response here than to wait for that to come up. If users don't have permissions to ...
1
vote
1answer
361 views

Excel web access webpart throwing javascript error ( in ewamoss.js) in IE10

I am using Excel web access web part to display Excel reports in Sharepoint 2010. It's working fine with IE9. When I am loading the report in IE 10, it's throwing the error "Unable to get property ...
1
vote
1answer
180 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. ...
1
vote
2answers
2k views

Excel Services permission error

I'm using SharePoint 2007. Some users are getting an error when trying to open a spreadsheet from the SharePoint. You do not have permissions to open this file on Excel Services. Make sure that the ...
1
vote
1answer
610 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
1answer
258 views

Office Web Apps Word - Configure trusted locations

It is possible to configure the trusted file locations for the Word Web App on SharePoint 2010? I only can find the settings to configure the supported file formats at the Word-Service Application ...