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

0
votes
1answer
216 views

SharePoint 2007 Excel Web Access Port Number Issue, I think

I am using the following url to display an excel document in the browser: ...
0
votes
2answers
232 views

Hard limit to have number of Excel webparts on SharePoint 2010 page?

Is there any hard limit to have number of Excel webparts on the SharePoint 2010 page?
0
votes
0answers
175 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 ...
1
vote
1answer
387 views

Scaling Excel Service Application - SharePoint 2010

Today I was preparing a new production server farm for SharePoint 2010 when I encountered this fact that there are not many in depth articles/whitepapers on the net that deals explicitly with Excel ...
0
votes
1answer
108 views

What is the best option you would use to show dashboard data within an Excel file on SharePoint?

What is the best option you would use to show dashboard data within an Excel file on SharePoint? A. SharePoint and MS Office Integration. B. SQL Reports integrated with SharePoint. C. ...
1
vote
2answers
208 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 ...
0
votes
1answer
609 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 ...
1
vote
0answers
424 views

Customize toolbar in xlviewer.aspx

We would like to replace the "Open in Excel" button with the "Download a snapshot" command in the xlviewer.aspx file. Is this something you can configure when using this file to view documents? I ...
1
vote
0answers
225 views

Value error in UDF with Excel Services

I've written some C# User Defined Functions for Excel that I'm trying to run in Excel Services. One of these UDFs is working in my local environment, but failing in the QA environment. Instead of ...
0
votes
2answers
374 views

Excel Web App error everyday after recreation

I try to View/Edit Excel documents (xlsx) in Office Web App SP1. I immediately get an error. "An unexpected error has occurred.". Word and Powerpoint both work fine. I have recreated the Excel Service ...
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
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 ...
1
vote
0answers
40 views

How to add EWA parts with the non-enterprise version

Is it possible to add a Excel Web Access part to a dashboard in the non-enterprise version? If not, is there another way to simulate such a dashboard?
2
votes
1answer
711 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
0answers
61 views

Can Formulas Automatically Update in Excel Services 2007?

I currently have two spreadsheets housed in Excel Services in a Sharepoint Hub. These two spreadsheets are linked. However, the values on my main spreadsheet will only update 1. if the source ...
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
525 views

Excel Web Access & VSTO

I created an Excel workbook in Visual Studio 2010 using VSTO, and it fills a table with data retrieved from a WCF service. The service was added to the project using the standard "Add Service ...
1
vote
1answer
178 views

Excel Web Services Error

I have uploaded an xlsx file that I would like to use EWA to display using Excel Web Services. I have confirmed that the site is a trusted location and Excel Web Services is configured correctly from ...
1
vote
1answer
275 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 ...
6
votes
1answer
754 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 ...
3
votes
2answers
878 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?
0
votes
1answer
256 views

MOSS 2007 Excel Services - Show all Rows and Columns?

We're running SharePoint 2007. Is there a way to disable the arrow navigation buttons in Excel Services and instead display all rows and columns in the worksheet so the user can use the browser ...
0
votes
1answer
536 views

Powershell command for Excel Services?

Is there a powershell to restart the excel services? If yes, what is the syntax to restart the excel services.
1
vote
1answer
201 views

Why am I getting a ServerContext.Current error using Excel Web Services? [closed]

We are trying to setup Excel Web Services in SharePoint 2007 and for some reason all accounts are getting an error. When I check the event logs, I see the following error: ...
2
votes
3answers
666 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
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. ...
1
vote
1answer
590 views

401 authentication error when calling OpenWorkbook method of ExcelService.asmx

We are trying to call the Excel Services web service using SOAP with a Sharepoint/domain admin account. I see 401.2 errors in the IIS logs. There is no user name specified there. We are using ...
0
votes
1answer
571 views

Is it possible to set up an ODBC connected Excel spreadsheet on SharePoint 2007 with a Standard license?

I know that many database connections are possible with the Enterprise version of SharePoint Server 2007. Is it possible to make a custom solution to set up a connection? If it depends on the type ...
0
votes
1answer
300 views

Excel Services delegation using Classic Mode Authentication

Every where I'm reading about setting up Excel Services for delegation so that it can connect to Analysis Services running on separate server is based around using Claims based authentication to ...
0
votes
1answer
448 views

Opening Excel services session returns “Safe handle has been closed”

Has anybody else had problems with Excel Services in SP2010? I am trying to programmatically access Excel web services. To connect to Excel services, I am direct linking to the ...
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 ...
0
votes
1answer
438 views

Sharepoint dashboard and KPI

Is there any way to create a dashboard, and use KPI from a shared doc lib that contain excel sheets ? thanks
1
vote
2answers
490 views

Excel Web Services/Pivot Filters not functioning and MOSS 2007

I am currently struggling with an issue with Excel Web Servces and pivot tables. We have several site collections in which we expose pivot tables with filters through EWA web parts. The issue is ...
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 ...
0
votes
3answers
477 views

How do Excel Services Sessions work?

We are using web services interface to access Excel Services. When we have two sessions that access the same spreadsheet, it looks like they see each others data. Is this how it is supposed to work? ...