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
2answers
2k 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 ...
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 ...
4
votes
1answer
193 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 ...
1
vote
1answer
36 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 ...
1
vote
1answer
33 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 ...
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
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
1answer
76 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
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
1answer
613 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
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. ...
2
votes
0answers
46 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 ...
2
votes
0answers
159 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
43 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 ...
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 ...
1
vote
0answers
38 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
30 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 ...
1
vote
0answers
164 views
Value error in UDF with Excel Services
I've written some C# User Defined Functions for Excel that I'm trying to run in Excel Services. One of these UDFs is working in my local environment, but failing in the QA environment. Instead of ...
1
vote
0answers
296 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 ...
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
167 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
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
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
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
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
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
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
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 ...
