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.

109 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
131 views

Excel data doesn't appear, in the Excel Web Access

I've added an Excel Web part into my page. I did check out this excel workbook. But, when I want to run my page , I'm getting as follows error. Also,when I want to open xslx file in my desktop, the ...
1
vote
1answer
151 views

SharePoint 2010 Multi Tenant - I need Excel Services

We are running SP in Multi-Tenant mode for a few small clients. I need Excel services enabled for two of the tenants. What options do I have and how do I do it? I have been looking at documentation ...
1
vote
1answer
389 views

Since last patch, unable to open excel documents and word documents can only be opened by dropdown

We performed updates to the SharePoint Portal, SharePoint Foundation, Office Sharepoint Server, Excel Services Component, and Word Server on 03/16/2014. Since then, we are unable to open Excel ...
1
vote
0answers
556 views

Issue with Office Web Apps - can't open Excel file, prompt for user name and password

I can't open by Office Web Apps Excel file, SharePoint always prompt for user name and password and after entering correct user name and password it happens again and get error: "An error has ...
1
vote
0answers
249 views

How can I remove Excel menu in web apps in Share Point 2013?

I use SharePoint 2013 and I use Power Pivot Service. When I open an Excel Report, I see this report : How can I remove Excel menu(File/Open In Excel / Data/...) from this report?
1
vote
0answers
102 views

Excel Services permissions error

I have created a document library, and gotten that library added to the Excel Services Trusted Locations in central admin. I’m using an account which has full control on the document library to ...
1
vote
0answers
765 views

Hyperlink to force Excel to open in Excel Services

We have found that a link, like the following, pasted into an Outlook email will always open the target file in the users local copy of Excel: <http://ourspbi/myreports/Some Excel report 20Jan2014....
1
vote
0answers
978 views

Problem connecting Sharepoint 2010 to SSAS through a RSDS

As the title says, I'm trying to create a Report Data Source on Sharepoint 2010 where I have an SQL2012 instance with the PowerPivot, SSRS and the sharepoint add-in configured. I choose "Microsoft ...
1
vote
0answers
49 views

Make First Sheet Display in Excel of Sharepoint in Browser

I have a Excel Web part and make an excel appear in browser throught this web part. There is 4 sheets in excel but when I open the page , firstly the third sheet appears but not he first sheet. How ...
1
vote
0answers
3k views

Export Excel Table to Sharepoint List throwing publishing error?

I have a SP Foundation 2010 installation on windows 7. I created a OOTB Contacts list in SharePoint and tried exporting an excel (Office 365) table with various fields to this list. Note: The column ...
1
vote
0answers
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
0answers
451 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 ...
1
vote
0answers
373 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
1answer
380 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 ...
1
vote
1answer
56 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
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
0answers
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 ...
1
vote
0answers
291 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
602 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
48 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
65 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
1answer
21 views

Migrating from Sharepoint 2013/excel services to Office 365

Does anyone know of a migration path from Sharepoint 2013/Excel Services to Office 365? We have a bunch of Excel workbooks stored in SP 2013, which we calculate using Excel Services via the Excel ...
0
votes
1answer
63 views

How to suppress Excel Services query warning in Sharepoint online?

I am using Excel Services to display items from an Excel workbook that has a query connection for its data. Each time I load the Sharepoint page, the Excel Services web parts ask if I want to run the ...
0
votes
0answers
80 views

Error: The data connection uses Windows Authentication and user credentials could not be delegated

Environment: SharePoint 2016 (On-prem) with on-prem Office Online When users attempt to navigate to an Excel file with an embedded datasource, they receive the following error: The data connection ...
0
votes
1answer
173 views

Connect excel file in Excel Web in Sharepoint to external SQL server

It is the first time that I am using the web version of excel with external data sources on Sharepoint so I hope that you can help my with that. I do have an Excel list that grabs data from an on-...
0
votes
0answers
31 views

Rest API Excel Services error forbidden

We have created a SPD workflow with below details: URL: **/_vti_bin/ExcelRest.aspx/Shared%20Documents/test.xlsx/odata/Table1 Headers: Accept: "application/json;odata=verbose" Result: d/result(0)/...
0
votes
0answers
24 views

Excel file saved as htm to render properly when uploaded in SharePoint library

I use DriveToWeb to host a webpage (and supporting files) with OneDrive. My website is basically an Excel file saved to .htm file so it has supporting files. Why do I save Excel files to .htm files ...
0
votes
1answer
28 views

SP 2010: Excel Calculation Services is not restarting

Excel Calculation Services is not restarting, and when researched, i found an error There was an error in communicating with Excel Calculation Services http://server:32843/...
0
votes
1answer
46 views

How can i find the Excel services URL for my file?

I'm trying to access through the Excel Rest API an excel file "My Excel File.xlsx", but regardless how I what excel services URL I use, I either get 404 or file does not exist or is deleted. This is ...
0
votes
1answer
914 views

How do I use the Get Data function / From File / From Sharepoint folder within Excel?

What I am wanting to do is link up to 4 different workbooks together that we have on our company sharepoint. The problem is I have not been able to find a way to link workbooks together in sharepoint ...
0
votes
1answer
28 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
139 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
1answer
360 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
160 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
662 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
167 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/...
0
votes
1answer
125 views

excel upload with only specific columns

I'm trying to upload an Excel file to SharePoint, but i would like to only upload columns AL, B, and AU, and wondering if SharePoint has a way to do this, or if Excel has a way i can upload it to a ...
0
votes
0answers
1k views

Login prompt for opening a office document from SharePoint library in IE.

There are few excel files in my SharePoint 2010 library which is a public facing site. Now when I click on the files from Chrome browser, the files get downloaded in my machine but when I try from IE(...
0
votes
1answer
665 views

SharePoint 2010 Services on Server not showing some services on some servers

SharePoint 2010 Services on Server not showing some services on some servers One server I can see all services, but when I change to a different server it only shows some services. This is a 3 WFE ...
0
votes
1answer
236 views

Excel file not opening in sharepoint 2013

I am using SP2013 & created a site. I have used document library to store the documents in my site but the excel documents doesn't open it shows this error:- "We're sorry. We run into a problem ...
0
votes
1answer
2k views

Unable to save workbook in SharePoint Online / Office 365

We have a team site with a document library with 4 excel documents in it. When we want to edit the document using the Excel online editor we get an error: "Unable to save workbook". The changes are ...
0
votes
2answers
44 views

SharePoint 2010 PowerPivot DAX functions

Hi I have a PowerPivot with a calculated column that returns data via the RELATED function. The columns works perfectly except for a handful of rows that return an empty cell. After some ...
0
votes
0answers
53 views

Excel Service Application Error 5244 in Sharepoint 2010 Standard

We are seeing a lot of Excel Service Application errors in the Event logs, even though there is no Excel Service available in sharepoint 2010 standard that we are using. How can I find out where this ...
0
votes
1answer
1k views

Change Excel web access dynamically using javascript

I have a page with a button and an Excel web part. When I click on the button I want to load another Excel file in that web part. Is it possible to do this? Please suggest some ideas on it.
0
votes
1answer
21 views

Offline doc linking to sharepoint doc (specifically excel)?

I searched for an answer to this and the various answers left me confused, so I figured I'd come here now since I always get a reliable answer from this forum. I have Office365 and I use Excel Online ...
0
votes
0answers
222 views

SharePoint 2013 Excel WebPart

I created new excel webpart. I got this error : The trial period for SharePoint Server has expired. I researched on net and i found this solve : Run--> inetmgr-->Application Pools--> ...
0
votes
0answers
625 views

Restore Errors on Sharepoint

I got up backup a server. And I want to restore the backup to nother server. But I got this error and my restore job is failed. Object Excel Service Application failed in event OnRestore. For more ...
0
votes
1answer
63 views

I need help - some excel docs not opening in sharepoint

Many excel files in our libraries are no longer able to be opened. They can be downloaded via the drop down menu, but will not open with a click as they should be. The pop-up message we get is; "...
0
votes
1answer
47 views

Overlay in Excel Services Chart

I have a chart in an Excel document that I am displaying on a Web Part page. In Excel, I was able to draw a text box and overlay a percentage. However, these types of objects are not supported by ...
0
votes
1answer
509 views

How to exctract filtered items from SharePoint List to Excel

I'm using Javascript and AngularJS to get all data from a SharePoint list in JSON and displayed it into a table. User can sort it, filtered it and etc. There is a really nice paggination. Everything ...