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

7
votes
6answers
23k 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
771 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 ...
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 ...
4
votes
4answers
3k 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
660 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
546 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 ...
4
votes
1answer
2k 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 ...
4
votes
2answers
382 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
20k 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
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 ...
3
votes
2answers
1k 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
2k 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 ...
3
votes
3answers
18k 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 ...
3
votes
2answers
9k 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
2k 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
18 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 ...
3
votes
1answer
135 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
230 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
881 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
107 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
16k 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
671 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
299 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
83 views

Unable to export all the data from Share Point list

In my Share Point list has 23072 records, but I am able to exports only 2000 records. It has multivalued, Lookup, Yes/No & Calculated type columns and around 64 columns are there. Any ideas, How ...
2
votes
1answer
45 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
19k views

Excel links open files as read-only mode. How to change this to edit mode?

Does anyone have any idea why using the link on excel opens the file as read-only mode? How can I change the behavior to open as Edit mode? I checked almost all of the Document Library settings, ...
2
votes
4answers
8k 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
95 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
11 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
2
votes
1answer
47 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
2
votes
1answer
70 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 ...
2
votes
0answers
1k 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
1k 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
58 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
0answers
104 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
452 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
724 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
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. ...
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
1answer
2k 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
2answers
609 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 ...
1
vote
1answer
439 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
547 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
8k 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
65 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
672 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
2k 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 ...