0
votes
1answer
45 views

SharePoint 2010 - Excel Web App error “An error has occurred. Please try again.”

On one of SharePoint sites on our server. While opening few .xlsx files users(including me) are getting the error "An error has occurred. Please try again.". When the user click's on any of these ...
0
votes
2answers
77 views

How to know if Excel Services is available on SharePoint?

I'm using a Sharepoint 2010 server. Unfortunately, I'm not the administrator and I'm not able to connect with him. But I want to know, if Excel Services is installed and activated. I'm able to edit ...
0
votes
1answer
128 views

Get-SPExcelServiceApplication Cmdlet not recognized during Powerpivot configuration

I am trying to run the sharepoint powerpivot configuration tool however I am getting a message saying: The term 'Get-SPExcelServiceApplication' is not recognized as the name of a cmdlet, function, ...
1
vote
1answer
160 views

Since last patch, unable to open excel documents and word documents can only be opened by dropdown

We performed updates to the SharePoint Portal, SharePoint Foundation, Office Sharepoint Server, Excel Services Component, and Word Server on 03/16/2014. Since then, we are unable to open Excel ...
1
vote
0answers
44 views

Excel Services permissions error

I have created a document library, and gotten that library added to the Excel Services Trusted Locations in central admin. I’m using an account which has full control on the document library to ...
0
votes
1answer
118 views

Read from an excel Sheet and write to a List

My requirement is that, i need to upload data from an excel sheet to an existing sharepoint List in SP 2010.I will have 2 different Lists Like this. Then I need to compare Both the List and retrieve ...
1
vote
2answers
385 views

Excel Web Access Web Part won't display workbook

We've recently upgraded from SharePoint 2007 to 2010 and we are trying to get the Excel Web Access web part to work. Excel Services is running if that's required, the workbook location is configured ...
3
votes
3answers
19k 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 ...
0
votes
1answer
38 views

Regarding excel service in sharepoint 2010

We planning to purchase Sharepoint 2010 standard version. I notice SharePoint 2010 standard version does not support Excel service. My question is, am still able to load the excel document in ...
2
votes
0answers
485 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: ...
1
vote
0answers
59 views

Missing rows in PerformancePoint Dashboard chart compared to Excel Services

Excel which is published has more than 75 rows but in dashboard there are only 75 rows for the report.Are there any parameters are set for this in dashboard designer or any other changes are required. ...
0
votes
1answer
185 views

Are Sparklines Viewable via excel services and Business Intelligence?

I have an excel report with SparkLines in it. When I view the file through excel services (aka in the browser), all looks fine and dandy. But when I try to browse the file via REST services, the ...
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, ...
0
votes
1answer
584 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
85 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 ...
1
vote
1answer
704 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. ...
7
votes
6answers
24k 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
535 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 ...