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.
299
questions
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 ...
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 ...
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 ...
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.
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 ...
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 - ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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/...
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?
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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.
...
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 ...
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 ...
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 ...
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 ...
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 ...
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, ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 '...
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 ...
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 ...
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 ...
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.
...
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 ...
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!...
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? ...
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?