Questions tagged [excel-services]

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.

Filter by
Sorted by
Tagged with
2 votes
1 answer
3k views

Not able to refresh External data in Excel SharePoint 2010

I am not able to refresh the data in Excel when to see the excel report in a browser. When I press Refresh All options the page gets refresh but no update in data is reflected. Actually, I have two ...
Pallavi's user avatar
  • 21
0 votes
1 answer
870 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 ...
Jijeshan009's user avatar
1 vote
1 answer
1k views

Excel Services - Disable Refresh warning

I'm trying to figure out how to disable the refresh warning used within Excel Services. Everytime I load my page I get the following: My first port of call was to check the trusted file location for ...
Ian's user avatar
  • 151
1 vote
0 answers
813 views

SP2103 Excel-Services Freeze Panes / Headers

Do anyone know a simple solution to freezing the headers in an Excel file that is published on a SharePoint 2013 portal.
Yves's user avatar
  • 11
1 vote
0 answers
453 views

Enable Publishing Options button without SharePoint Designer

We use MS Office 2010 Standard, and some users will be publishing spreadsheets from Excel to SharePoint (2010). We have discovered, however, that the Publishing Options button only appears in the Send ...
Steven's user avatar
  • 11
0 votes
2 answers
7k views

Excel services and PowerPivot error: "Unable to refresh data for a data connection in the Workbook. "

My environment is a 3-tier SharePoint 2010 Architecture: Running on SQL Server 2012 Enterprise Edition WF1 WF2 Both Web Fronts are NLB, and we have they following Application Servers APP1 - ...
Sepaka's user avatar
  • 550
5 votes
1 answer
4k 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 ...
Rameez's user avatar
  • 83
0 votes
1 answer
831 views

SharePoint 2010 List Excel Export Error

I have some problems about exporting a SharePoint List to excel. I'm getting "Excel cannot connect to the SharePoint list" error while exporting it to excel. There wasn't any error in the same list ...
newbie's user avatar
  • 1,737
2 votes
1 answer
27k 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 ...
Muhammedh's user avatar
  • 1,157
1 vote
2 answers
2k 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 ...
Kirk's user avatar
  • 231
7 votes
4 answers
10k 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 ...
ArkoD's user avatar
  • 5,304
0 votes
1 answer
222 views

Implementation of power view in sp 2013 - Pain Points and Ideas

Can anybody please give me some painpoints of using PowerView in sharepoint 2013. Recently in our project we are planning to upgrade our site from SP2010 to 2013. In SP2010 site we have lots of ...
alam235's user avatar
  • 328
3 votes
4 answers
74k 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 ...
Dkong's user avatar
  • 395
0 votes
1 answer
40 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 ...
Spidey's user avatar
  • 103
1 vote
0 answers
376 views

Adding Excel Reports / TFS Web Part to My Site

I'm using Sharepoint 2013 and would like to add some Excel Reports to "My Site" but I don't know where to begin. Excel Services have been configured correctly since we also have the team foundation ...
hoetz's user avatar
  • 101
2 votes
0 answers
165 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 ...
SPDeveloper's user avatar
1 vote
1 answer
1k views

Powerpivot data refresh over kerberos delegation

I have a SQL 2008 R2 OLAP Cube and an Excel file that uses powerpivot and embedded datasource to the Cube. I want to upload the Excel file in SharePoint and allow users who are authenticated to the ...
ArkoD's user avatar
  • 5,304
4 votes
0 answers
927 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: /System/...
ioan's user avatar
  • 81
0 votes
1 answer
626 views

How to convert Sharepoint 2010 Chart web part to Excel?

I want to convert chart webpart's chart to excel format how it is possible?
Jignesh's user avatar
  • 33
1 vote
2 answers
5k views

Unable to refresh data for a data connection in the workbook.

I am trying to use an Excel Web Part that connects to a list in Sharepoint 2010. On my local drive the spreadsheet updates when I open it and all is well but when I uploaded to sharepoint the data ...
user14522's user avatar
1 vote
1 answer
577 views

If a user can't read Excel file, can they still view Chart Web Part created from it?

Title sums it up. I would just try it myself but my test environment is down and I figured I might get a speedier response here than to wait for that to come up. If users don't have permissions to ...
caleb.breckon's user avatar
12 votes
8 answers
287k 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, but ...
MicroSumol's user avatar
1 vote
1 answer
385 views

issue with Excel Services in SP2010

I have created a Excel and enabled the connection to external sQL database through Secure store service and created the odc file . When i open the excel in sharepoint it refreshes the data and it is ...
Jagadeesh's user avatar
0 votes
1 answer
577 views

How to use ExcelServices in Sharepoint?

I want to use the Excel workbook in my SharePoint using ExcelServices. I have done all settings in "Excel Services Applications" & "Secure Store Service" in "Manage Service Application" option ...
Shahid's user avatar
  • 229
0 votes
2 answers
355 views

Starting Service Applications on SharePoint2010

I have noted that some of the service applications on my central admin are in stopped status, so i want to start them and don't no how to start them as I won't see any start option available on that ...
shreyas's user avatar
  • 175
1 vote
1 answer
106 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 ...
Jakob S.'s user avatar
  • 113
3 votes
1 answer
298 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 ...
Umesh's user avatar
  • 31
1 vote
1 answer
57 views

Excel Services User Defined Function returns #NAME?

I've followed all the steps as described in numerous blog posts, including the MSDN Walkthrough, on setting up User Defined Functions in Excel Services. However, I'm still getting "#NAME?" in the ...
Sam Larko's user avatar
  • 146
1 vote
0 answers
64 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. ...
Gautam Shukla's user avatar
1 vote
0 answers
71 views

Fact tables indicators selectors/filters in an excel report with pivot tables

I'm working in a project where I need to publish some reports based on excel pivot tables against SSAS cube. Until here everything is OK. However, I want to know how I can set in my excel report a ...
swcast's user avatar
  • 11
0 votes
1 answer
4k views

"Access Denied" when attempting to view Excel workbook

After uploading a workbook to a newly created PowerPivot Gallery, attempting to open the uploaded workbook displays: I am logged in as a Site Collection Administrator and have verified that Excel ...
lukiffer's user avatar
  • 371
4 votes
1 answer
1k 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 ...
Brandon Michael Hunter's user avatar
0 votes
1 answer
433 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 ...
ewitkows's user avatar
  • 165
0 votes
1 answer
208 views

Excel Calculation Services - Excel Web Apps

We're trying to co-author excel workbooks but only have Standard CAL/Sharepoint 2010 Standard Server license. Its my research so far that to have co-authoring for Excel, we would need to use Excel ...
Catherine Ahearn's user avatar
4 votes
4 answers
7k 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, ...
ewitkows's user avatar
  • 165
0 votes
1 answer
1k 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 ...
ewitkows's user avatar
  • 165
0 votes
2 answers
535 views

Create new Workbook using Excel Services

I want to generate an Excel File using SharePoint. I can make a reference to ExcelServices and want to use the function NewWorkbook. But I am getting the error which say Soap Exception: You do not ...
Active_t's user avatar
3 votes
5 answers
36k 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 ...
Troy's user avatar
  • 73
0 votes
1 answer
177 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 ...
Ruben Herman's user avatar
  • 2,744
0 votes
1 answer
3k 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 ...
Tudor's user avatar
  • 432
1 vote
1 answer
737 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 ...
user7400's user avatar
  • 1,266
1 vote
2 answers
1k 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 '...
Ram Yadlapalli's user avatar
0 votes
1 answer
4k 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 ...
user7400's user avatar
  • 1,266
0 votes
2 answers
4k 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 ...
idlemind's user avatar
  • 151
1 vote
3 answers
5k views

Unable to Refresh the Excel Connection in Excel Webaccess Webpart

I am using an excel workbook with pivot in it. I am using the Excess webpart to display it. As I click on the Refresh all data connection. It throws an error.The scree shot is attached. I have ...
Kishan's user avatar
  • 134
1 vote
2 answers
333 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. ...
user7400's user avatar
  • 1,266
0 votes
1 answer
2k views

Event Attachments Opens Excel Spreadsheets in XLViewer

I have a calendar list with attachments enabled. When i attach an XLS file to an event, SharePoint wants to open it in xlviewer.aspx, but throws an error every time. I don't want to open the file in a ...
Markus's user avatar
  • 349
0 votes
1 answer
257 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: sharepoint-server:29769/_layouts/xlviewer.aspx?id=http://sharepoint-server:29769/Documents/Cancer/Graphs.xlsx&range=Brain!...
Imran Azad's user avatar
5 votes
2 answers
5k 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? ...
sa.ho's user avatar
  • 53
0 votes
2 answers
442 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?
Karthikeyan's user avatar
  • 2,548