The excel-services tag has no wiki summary.
0
votes
2answers
56 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 ...
1
vote
0answers
17 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 ...
2
votes
2answers
42 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
29 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 ...
2
votes
2answers
30 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 ...
0
votes
1answer
28 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 ...
2
votes
0answers
43 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 ...
1
vote
0answers
17 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?
1
vote
0answers
10 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
2answers
59 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 ...
0
votes
3answers
142 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. ...
2
votes
1answer
89 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 ...
0
votes
0answers
74 views
SharePoint 2010 - ExcelService.GetRange() returns empty cells
I am trying to retrieve data from a spreadsheet in a document library on SharePoint Server 2010. I have managed to successfully open the workbook and I then call ExcelService.GetRange() as shown ...
0
votes
0answers
49 views
Get populated rows in spreadsheet using ExcelServices in a SharePoint 2010 web part
I have a visual web part that retrieves an excel workbook from a document library on SharePoint Server 2010. I am opening the workbook using Excel Services (as a normal reference, not a web reference ...
1
vote
2answers
53 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
0answers
77 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
58 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
...
0
votes
1answer
95 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
3answers
682 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 ...
1
vote
1answer
125 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 ...
6
votes
1answer
301 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
...
2
votes
0answers
72 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 ...
1
vote
2answers
3k 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
119 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 ...
1
vote
1answer
119 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:
...
1
vote
2answers
1k 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 ...
1
vote
1answer
523 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
3answers
388 views
Can an Excel file be used as an external content type?
or an external datasource? Can that be set up in SP Designer 2010
0
votes
1answer
250 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 ...
1
vote
1answer
255 views
Excel Services, Save As does not show Publish Options
I have created a document library and configure it to have a Document Template Excel Spreadsheet. When I create a new Document and then save the new Excel worksheet, by selecting File -> Save&Send ...
0
votes
8answers
6k 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 ...
1
vote
1answer
103 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 ...
3
votes
2answers
502 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
250 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 ...
0
votes
1answer
234 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
327 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
440 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 ...
1
vote
3answers
194 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
2answers
60 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 ...
1
vote
2answers
379 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 ...
3
votes
2answers
5k 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
3answers
387 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? ...
