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.
0
votes
0answers
129 views
Excel Services - how to extract chart images from a user-modified EWA, not the source file
How can I get the image (png) of charts in an open/live Excel Web Access web part. I want to use the images outside of the EWA (e.g. pass them to c# so they can be used elsewhere or incorporated ...
0
votes
1answer
227 views
Excel Services Permissions
were setting up our SP2010 environment, and were looking to make use of excel services. Before we go all-in on excel services however, we have some causes for concern. Can anyone help define the ...
0
votes
1answer
77 views
Create new Worbook with Excel Services
I want to generate an Excel File with SharePoint. I can make a refernce to ExcelServices an want to use the funtion NewWorkbook. But i get the error : Soap Exception: You do not have appropriate ...
3
votes
3answers
10k 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
525 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? ...
0
votes
1answer
61 views
Versioning in Excel web app
Does anyone know how it's possible to create major and minor versions in the excel web app?
When a document is saved, I see that it changes the minor version, but what do I need to do to create a new ...
0
votes
1answer
305 views
Tracking Changes to Individual Cell in Excel Spreadsheet on SharePoint?
I've gotten a weird request today, someone I work with asked if there is any way to track changes to a specific cell in an Excel Spreadsheet. The spreadsheet is hosted on SharePoint and they want to ...
2
votes
4answers
11k 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
186 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 ...
1
vote
1answer
246 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
2answers
391 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 ...
0
votes
1answer
518 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 ...
0
votes
2answers
1k views
SharePoint 2010 TfsOlapReport Excel Services throw OLEDBConnection error
I'm trying to fix the "failed to refresh: TfsOlapReport" error on the TFS project portal dashboards in SharePoint 2010. I've followed the instructions here to make sure the Secure Store Service and ...
3
votes
1answer
186 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 ...
0
votes
0answers
95 views
SharePoint 2010 Designer get data from Excel in DataView webpart
I em working with sharepoint 2010. I need to fetch data from Excel spread sheet(uploaded to the sharepoint server) in dataview webpart. Whether it is possible? If yes then how can i do it?
Regards,
...
0
votes
2answers
851 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 ...
0
votes
1answer
128 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
175 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
145 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
116 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
282 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
86 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
141 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
333 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
297 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
4k 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 ...
1
vote
0answers
166 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
248 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
1k 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
96 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
35 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
437 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
53 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 ...
0
votes
3answers
2k 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
366 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
154 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
216 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
615 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
816 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
234 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
322 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
1k 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
1
vote
1answer
173 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
525 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 ...
1
vote
1answer
1k 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
536 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
1answer
472 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
1answer
503 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
282 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 ...
