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.
1
vote
0answers
13 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
1answer
20 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 - ...
1
vote
1answer
40 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
0answers
18 views
Is it possible to use Powerview with SharePoint 2010 SP1 on SQL Server 2008 R2
I have a SharePoint 2010 SP1 environment configured over SQL Server2008 R2.
I have an Analysis Server running on a separate physical server which is also SQL 2k8 R2. I want to create a powerview ...
0
votes
0answers
52 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 ...
1
vote
1answer
220 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
0answers
46 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
4answers
199 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
1answer
43 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 ...
0
votes
0answers
22 views
Workflow For Updating To A List(Sharepoint)
I have created a workflow to add the values from excel sheet in SP list...I want to create a condition such like whenever the excel is modified its values should get reflected in the list.. I Am Using ...
2
votes
2answers
324 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
29 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 ...
0
votes
0answers
181 views
SharePoint 2010 PowerPivot Excel Web Access dynamic refresh
We have SQL Server 2008 R2 (x64) with MSOffice 2010 (x64) and PowerPivot x64.
We created a custom list "InformationList". We then used the "Export as Data Feed" option to generate a .atomsvc file ...
0
votes
0answers
63 views
Custom Error Message-Unable To Process Request(Sharepoint 2010)
I have an Excel Web Access Webpart. I want a custom error message to be displayed when an invalid excel workbook is trying to be imported.
Step By Step Explanation is expected as I am new To ...
1
vote
0answers
66 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 ...
0
votes
0answers
46 views
Is there a way to prevent Excel Web Access from loading it's workbook on page load?
I have a sharepoint page that I am working with and it contains an Excel Web Access Web Part. That EWA Web Part is used to display and filter a large report that connects to an OLAP cube, and takes ...
2
votes
0answers
48 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
1answer
80 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 ...
2
votes
0answers
162 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: ...
0
votes
1answer
132 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?
0
votes
0answers
135 views
Unable to refresh data for a data connection in the workbook. Try again or contact your system administrator
I am using SharePoint 2010. My Excel file is saved in document library. The data connection library has the data source, which brings the data into Excel from SQL Server 2012 cube.
The problem is ...
1
vote
1answer
366 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
1answer
90 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 ...
0
votes
1answer
2k 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, ...
0
votes
1answer
79 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
0answers
72 views
How can I schedule recurring email in sharepoint 2013
I have set of Power View reports and Excel reports on Sharepoint 2013. Is it possible to schedule email to send snapshot of Power View and Excel reports daily to a set of users?
0
votes
1answer
191 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
2answers
33 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
1answer
35 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 ...
0
votes
0answers
78 views
Bind Sharepoint List Fields with excel columns
Hi i have to bind Excel columns to Sharepoint list Columns and my excel contains not just a simple Grid. It is a template which looks like this :
is it possible to bind this straight forward like ...
3
votes
1answer
54 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
1answer
34 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
0answers
39 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
0answers
32 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
1answer
293 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
1answer
198 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
0answers
102 views
Doc Library Template (Excel) cannot use macros?
So I uploaded an Excel template file to a document library so each time a new document ids created using 'Add Document' the template will be what the users fill in.
Now this template has two macros, ...
0
votes
1answer
81 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
1answer
82 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 ...
3
votes
4answers
766 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
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
226 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 ...
0
votes
2answers
3k 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
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 ...
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
245 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
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 ...
