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
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 ...
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?
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 ...
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:
...
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
469 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
6answers
340 views
Test drive of PerformancePoint and SSRS on SharePoint
I need to build advanced reports on SharePoint, where radars, pivots and cumulative values are involved. One obvious option is Excel Services, but I'd be interested to compare it with PerformancePoint ...
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. ...
0
votes
2answers
142 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
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
39 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
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
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
301 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 ...
0
votes
1answer
513 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 ...
0
votes
2answers
2k views
Excel Services permission error
I'm using SharePoint 2007.
Some users are getting an error when trying to open a spreadsheet from the SharePoint.
You do not have permissions to open this file on Excel Services. Make sure that the ...
0
votes
2answers
841 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
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 ...
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
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
3answers
459 views
How do Excel Services Sessions work?
We are using web services interface to access Excel Services.
When we have two sessions that access the same spreadsheet, it looks like they see each others data.
Is this how it is supposed to work? ...
0
votes
1answer
12 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 - ...
0
votes
0answers
15 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
42 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 ...
0
votes
0answers
21 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 ...
0
votes
0answers
170 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 ...
0
votes
0answers
45 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 ...
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
130 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 ...
0
votes
1answer
78 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
69 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
184 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 ...
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 ...
0
votes
1answer
286 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 ...
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
78 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
81 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 ...
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
220 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
74 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
0answers
94 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
1answer
127 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
614 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
1answer
174 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
0answers
114 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 ...
0
votes
1answer
84 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. ...
