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
0
votes
2answers
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 ...
0
votes
1answer
49 views

Excel service on sharepoint 2010

Trying to start excel services application web service application. The status just seems to be stuck on stopped. Timer service is running and so is excel calculation service. Any ideas?
0
votes
2answers
34 views

How does Excel Service applications worked on Sharepoint Online

I would like to know how to get my Excel Service applications on the Sharepoint Online started. As I am still quite new to this SharePoint Online environment and be working a lot on this environment ...
0
votes
2answers
281 views

Excel Web Access cannot open file

I have a site that was backed up and restored from one content database to a new content database using the below command. Backup-SPSite -Identity https://sp.domain.org/sites/thesite -Path D:\backups\...
0
votes
1answer
77 views

Excel Web Access web part get selected text in SharePoint Online

Anyone has idea on retrieving the selected text from excel access web part in SharePoint using javascript API? Requirement: I have an Excel sheet which has a big matrix (multiple rows and columns). ...
0
votes
1answer
47 views

Does Excel Services support connecting / refreshing external data that comes from another workbook?

I'm testing Excel Service via the Excel Web Access Web Part. I managed to make a working sample of a chart that retrieves its data from a SharePoint List. However, for some reason, I can't make a ...
0
votes
2answers
802 views

How to import table in excel to infopath form?

I have created the form template in excel. now I want to replicate the same in InfoPath.like I have created a table in excel and I want the table to import in InfoPath form. How to import selected ...
0
votes
1answer
98 views

Excel Online (many users but only one user is allowed to edit)

i have given many users have access to a excel sheet in Onedrive (excel online). Thats ok. Is it possible to give only one user access to sheet to edit. (the other users have to wait!) I want that ...
0
votes
1answer
230 views

Error viewing Excel sheets on mobile

I'm using SharePoint 2013, whenever I try to view an Excel file embedded in a SharePoint page through my mobile it gives me this message We can't start Excel mobile viewer because it may be turned ...
0
votes
1answer
799 views

Extract infopath xml data into excel

I have around 2000 InfoPath forms in SharePoint 2010 document library. I want to extract all forms in excel using macro. Any help?
0
votes
1answer
117 views

Sharepoint Excel files Capacity Planning

I have requirement to upload 30K records every year in document library and further attach workflow and do some stuff based on business criteria. I need to plan for capacity in SharePoint, so I need ...
0
votes
2answers
437 views

Customize xlviewer.aspx in SharePoint 2010?

We're using SharePoint 2010 and I have a requirement to hide the breadcrumb links at the top of the xlviewer.aspx page for Excel Services. I've found quite a bit of documentation on how to customize ...
0
votes
2answers
6k views

SharePoint 2010 - Excel Web App error “An error has occurred. Please try again.”

On one of SharePoint sites on our server. While opening few .xlsx files users(including me) are getting the error "An error has occurred. Please try again.". When the user click's on any of these ...
0
votes
2answers
5k views

Excel Services data refresh does not return updated data from data source

I have an Excel include some data which from a SharePoint list. This excel is created by using "Export to Excel" button of the SharePoint list form. I created a pivot table in the excel based on the ...
0
votes
1answer
2k views

Reading excel cell value in Excel Web Access Webpart

I need to read excel cell value.Excel web access webpart is used to display excel file stored in a SharePoint 2013 document library.I need to use Jquery to read the data of excel file currently ...
0
votes
2answers
4k views

Excel web services cannot open in browser

I have an odd issue where as some Excel files once clicked give me the option to open or edit and then some others when clicked launch directly into Excel Services within my browser. There appears to ...
0
votes
1answer
3k views

SharePoint 2013 - Excel Web Access - Can't Contact the server

I have a BI site configured with Excel and Reporting services and all the other required services. I have extended this site and all is fine when I use farm account accessing the site through Internet....
0
votes
1answer
90 views

Setting to enforce use of Excel Services rather than Excel Web App

Our site and sub-sites are defaulting to Excel Web App rather than Excel Services. We require Excel Services. I think maybe I hit a setting somewhere at the root which has caused this change. Where ...
0
votes
1answer
108 views

What is the purpose of Allow External Data Under Excel Service Application --> External Data?

We have a excel book that we can open via excel web part on sharepoint page. The excel book has external data connection to SQL Analysis server. Presently the setting for Allow External Data is set ...
0
votes
1answer
992 views

How to programatically modify contents of an excel sheet via excel web services in SharePoint 2013?

I have read that, While users can interact with Excel workbooks in a browser through Excel Services, the workbooks cannot be edited in the browser by using Excel Services. Programmatic options are ...
0
votes
2answers
2k views

Import File from SharePoint and Link this file with SharePoint (File- Excel File)

I am using SharePoint 2013 and Microsoft Office 2007 or above. Scenario: I upload a Excel file to a SharePoint 2013 list. Now, I want to import this Excel file from this SharePoint list back to ...
0
votes
1answer
675 views

Power View Report in Excel dont work in Share Point 2013 web site

I use Share Point 2013 and SQL Server 2008 R2 and Performance Point Service and I use Excel Service for show Excel Report in SharePoint 2013 web site. My SharePoint web site work and I can view Excel ...
0
votes
1answer
4k views

Access was denied by the external data source. The following connections failed to refresh: “data connection name”

I created an Excel report in Excel 2013 with a data-source as SQL stored procedure. I deployed this Excel report to Trusted Excel Library. I have done all configurations correctly in Excel Service ...
0
votes
2answers
6k 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
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 ...
0
votes
1answer
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 ...
0
votes
1answer
392 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
203 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
2answers
498 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 ...
0
votes
1answer
2k 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
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
1answer
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
1answer
255 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!...
0
votes
1answer
148 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. ...
0
votes
2answers
2k 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
522 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
282 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
633 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
506 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
0answers
21 views

Excel lost all recent changes, even though the versions are there

I have an excel sheet in sharepoint on premise that was opened and edited several times - I saved every now and then and the version number kept increasing, however when I closed and opened the file ...
0
votes
0answers
43 views

PowerPivot Management Dashboard Processing Timer Job failed with error, “We cannot locate a server to load the workbook Data Model”

All of sudden PowerPivot Management Dashboard Processing Timer Job has started failing in my SharePoint 2013 server. I have verified below: The Power Pivot SQL server instance is running SQL Server. ...
0
votes
1answer
25 views

After migration the custom Export excel is showing an error

After upgrading from SharePoint 2010 to SharePoint 2013 ,the custom Export All is displaying this error : An error occurred while generating your excel file, whereas the default Export to excel is ...
0
votes
0answers
12 views

WAS excel deletes the Title

I have a peculiar problem. When I edit an Excel file online (Web App Server server), it empties the Sp field Title. When I edit it using the pc Excel, everything is fine. I'm using a document library. ...
0
votes
0answers
50 views

Links to Excel files in doc libraries are opening differently for different users

I have a link to an Excel file in a doc library that opens in Excel Online. When opening it, some users are getting prompted to open the file in Excel 2016 and some users are getting prompted to open ...
0
votes
4answers
608 views

Be careful. This workbook contains one or more queries that might be unsafe

I try to display data using Excel services in a web part. First of all, my Sharepoint version is Sharepoint 2013; In addition, all authentication processes are working properly and I can retrieve the ...
0
votes
1answer
300 views

Links inside Excel files should open Excel files in another library

We have a bunch of excel files that contains so many relative URLs to other documents. Now we are uploading source file to one location (Document Library) in SharePoint and uploading the linked file (...
0
votes
1answer
133 views

sharpoint list doesn't connect to excel service via web browser

I am running with an issue which caused me a lot of waste time in vain, I customized a SharePoint with InfoPath 2013 and connected it to an excel file(using excel service)to perform some complicated ...
0
votes
1answer
572 views

Error while Refreshing Excel data using connection with SharePoint Online List

We have created a SharePoint list with 50000+ items in it which has different views. We exported the same SharePoint list using Export to Excel functionality. After that we created a dashboard on ...
0
votes
1answer
543 views

How do I fix “this range cannot be published due to an internal error” when trying to create a list from an excel file?

I have tried making sure there are no formulas in the file. I have started with a fresh file. I have checked the trusted sites in internet explorer. I am trying to upload from my users download folder....
0
votes
1answer
134 views

I am requesting the xlsb file from my sharepoint development site using rest API

the code is as follows., function getResponse() { var request = new SP.WebRequestInfo(); console.log(hostweburl); request.set_url(hostweburl + "/sites/techvision/ _vti_bin/...