Microsoft Excel is a commercial spreadsheet application, which can be integrated with SharePoint.

learn more… | top users | synonyms

0
votes
2answers
36 views

Files downloading instead of opening in Chrome

User is accessing SP through Chrome (rest of us have IE). When they click on a spreadsheet they don't get the usual prompt to select read only/edit mode. The spreadsheet opens and they make their ...
0
votes
0answers
10 views

Can not open an Excel document from SharePoint

My problem occurs only for Excel files from a SharePoint 2003 WSS2. I meet the problem with all versions of Internet Explorer Details of the problem: When clicking on the Excel file (screen 1) a ...
1
vote
0answers
14 views

SharePoint Online: Problem opening Excel

SharePoint Online Excel 2010 Internet Explorer 11 I've recently completed a SharePoint 2007 to SharePoint Online upgrade and am dealing with a few user issues in the project's wake. One user in ...
3
votes
2answers
27 views

Can you have multiple Excel worksheets for one SharePoint List?

I know you can create a table in Excel and export that into SharePoint as a list. I want to know if you are capable of having two or more Excel files updating a single SharePoint list. We want two ...
2
votes
1answer
20 views

Publish and Synchronize Excel 2013 as Sharepoint List

Can we publish and synchronize excel 2013 table as SharePoint list. I understand that using export to excel functionality and using data connection changes in the list gets reflected in the excel. But ...
0
votes
0answers
9 views

Export DVWP to formatted Excel spreadsheet

I've got a page on my SharePoint 2013 site that shows a report. The report itself is a DVWP, but I need the ability to export the report into a pre-formatted spreadsheet. I can currently right-click ...
3
votes
2answers
49 views

SharePoint - Embedding Excel using Excel services

We are trying to embed Excel using SharePoint Excel Services and we are getting the following error, We're sorry. We ran into problem completing your request. Please try again in few minutes ...
6
votes
2answers
226 views

Excel files always open in browser

On our Intranet I have activated the site collection feature "Open Documents in Client Applications by Default". On the Document libraries I have also set the *Default open behavior for ...
1
vote
1answer
23 views

How to access Excel cells hosted on Sharepoint (Office 365) using Java client?

I host my site in asphostportal and I am trying to build a Java clinet that connects to Sharepoint (mysite.sharepoint.com) and grabs an excel file. I used the Excel services WSDL file, however the ...
0
votes
0answers
16 views

Reading/Writing to excel

I have a requirement to read/write to excel. I am aware that it can be achieved by using Sandbox solution or provider hosted app. I am trying to do this via jquery. I came across this site which looks ...
1
vote
0answers
11 views

Users Cannot Open Document In folder to edit

I have a Site with a Document Library with a User with Full Control. We are running in https mode. The users cannot open the Spread Sheet for editing, though I can. The site is also asking her to log ...
0
votes
0answers
18 views

Excel preview in EditForm or DispForm - plug-in not supported

I have been troubleshooting this problem for a while now. When I open list item (that is excel or word file), then I will see empty area in IE and gray area in Chrome and Firefox, that give me ...
0
votes
1answer
19 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
0answers
26 views

Export to excel - Refresh every n minutes in excel greyed out

I exported sharepoint 2010 list to Excel 2010 and saved in a network location. I want to refresh the excel automatically for every 2 minutes. But the option "Refresh Every ... minutes" is greyed out ...
1
vote
1answer
17 views

Automaticly update connected excel file when a new item is added to a sharepoint list

I have a sharepoint list that we update daily and it is connected to an excel file that we update manualy. So what I would like is when a new item is added to the list it automatically updates the ...
1
vote
1answer
35 views

Using SP.FileCreationInfo to modify an .xlsx or .xls file

I'm trying to create a client-side solution where customers can download a template .xlsx document populated with data filtered from a SharePoint list. I know that JavaScript generally isn't used to ...
0
votes
0answers
4 views

Embed data sheet view of a list on a application page

I have a requirement where I need to show a data sheet view on a application page. Basically I have replaced the newform.aspx with a application page. This application page displays data from another ...
1
vote
0answers
10 views

Workbook.CheckIn always produces an error the first time it's called? (x-posted on StackOverflow)

This question is cross-posted on SO here. I have some workbooks stored in a document library on Sharepoint 2007. I want to check out a workbook, modify it, and check it back in. Using the following ...
0
votes
1answer
21 views

How to export to excel only items filtered on my view

In my specific list, I filtered to a account we are going to pay. Then when I click on "Export to Excel" button all the items of the list gets exported. How would I export data that I want? ...
0
votes
0answers
25 views

Office 365 for Mac(Yosemite) SharePoint won't open file in Excel.

File xlsx uploaded to SharePoint won't open using the Edit in Excel button. It appears to start, but not finish. Excel does not include this file in 'recent files', so cannot be opened from Excel. ...
0
votes
1answer
24 views

Can I apply check out rules to a single document in a document library and not the whole library?

Is it possible to apply check in/out rules to a single document in a document library without applying the same rules across the document library via the Library "Version Settings" section?
0
votes
2answers
20 views

Connection to SharePoint list on SP 2010/13 STANDARD Edition

My organisation will downgrade from SharePoint 2010 Enterprise Edition to SharePoint 2013 Standard edition. I am not part of the decision making, but I heard the decision relates to cost or licensing. ...
2
votes
1answer
57 views

Can I edit a workbook using Excel Services?

I created a web part putting my Excel worksheet on one of my Document Library, so I can have the live view of that worksheet without opening it again and again, my question is, can I edit that ...
0
votes
2answers
55 views

Creating Excel document using JavaScript

I've been researching into creating Excel documents in a SharePoint Library from an existing Excel template but all solutions I find are using server code. The Template can be part of a CT or in ...
0
votes
0answers
32 views

Excel 2013 Not Saving To SharePoint 2010 Library

I've got a peculiar problem with a couple of users having issues saving back their Excel document to their Document Library. As it is now, they'll have issues when they open the document from ...
0
votes
0answers
35 views

Auto refresh Odata connection between SharePoint list and MS Excel

I have an Odata connection set up in Excel Services to SharePoint list data. The Odata connection pivots the list data, then charts it in Excel Services, and the chart is hosted in SharePoint When I ...
0
votes
0answers
14 views

Problem with Excel View and Calculated Column

I have a problem both in Sharepoint 2010 and Sharepoint 2013 when I create a Excel View to list, and have got a Calculeted Column there after klick on calculeted Column I can edit Excel formulas and ...
0
votes
2answers
39 views

List Items Export to Excel on SharePoint 2013

I have a list on SharePoint 2013 and I want to export the list items to excel file. How can I do export process?
1
vote
2answers
74 views

Open Excel file in browser returns error

I have configured an excel document library to open in the browser. The file was published to the document library. The document library was set to open the file in the browser. When the file is ...
0
votes
0answers
17 views

Export to Excel does not export columns with multiple selections in SharePoint 2013

I am trying to export a list to Excel (Office 2013) that contains columns containing multiple selections, except the columns with multiple selections are completely missing from the exported Excel. To ...
0
votes
2answers
68 views

Pasting excel rich text column into Sharepoint 2013 list edit view

I was trying to paste an excel table to SP2013 datasheet view with one of the column is enhanced rich text editor. But the view stripped out the styling from excel table. Excel table: This is the ...
0
votes
0answers
29 views

Excel Connect to SharePoint Online Document Library

We have a number of people in the field who fill out fairly complex evaluation forms in excel. These forms are submitted to a document library in SharePoint Online What I need to be able to do is ...
0
votes
0answers
11 views

excel file uplodaded in sharepoint 2013 document library not opening

I have a document library in sharepoint where excel files are uploaded. But when we click on the excel file we are not able to view it. It give me the following error. Microsoft Office Excel cannot ...
1
vote
1answer
30 views

Excel Access Web Part changing my Top Navigation Bar

I am a newbie on this site. I am NOT a SharePoint developer or admin by trade. I have accumulated this job with on the job training. I am by far not an expert or claim to be. My issue is this, when I ...
1
vote
1answer
50 views

Sharepoint Excel Dynamic dashboard according to a list

I've a list which has something like this: List Title Status Title 1 Active Title 2 Pending Title 3 Active Title 4 Closed I need an Excel BI dashboard which should be dynamically ...
0
votes
0answers
53 views

Sharepoint 2013 Document Library Excel oData Data Retrive issue

I am trying to retrieve data from SharePoint Document library to excel using oData Data Feed. My Document library name is "2015" and it have one choice field. I am getting the following error when I ...
0
votes
0answers
35 views

VB script to automate importing sharepoint list data to excel

I need to automate pulling data from SharePoint list data to excel through writing a VB Script (not VBA). How can I import data directly from a SharePoint List into Excel using VB script? Currently, ...
0
votes
0answers
32 views

Hide toolbar menu commands on Excel Web Access web part

I'm displaying a Excel Web Access web part on a page in SharePoint 2010. I would like the users to be able to 'Download a Copy' of the workbook. However, I don't want them to to be able to select ...
0
votes
1answer
79 views

Cannot upload macro excel file

I have a problem with uploading macro (xlsm) files in a SharePoint Foundation 2013 Site collection. Strange is that on other SharePoint site collections which are on separate server farms, it works ...
0
votes
0answers
28 views

Excel Bi sharepoint online 2013 features - tutorial resources

Hi i need to work with Excel Bi and unable to find any resources except following link. I need to know what are the features, function available with Excel BI-sharepoint online 2013. ...
-1
votes
2answers
21 views

Excel Web Access issue

I embedded an Excel sheet into SharePoint using the excel web access web part. It works great, the only problem is that it continues to display the Excel sheet on refresh where it was last saved. I ...
0
votes
0answers
13 views

A webpart for Excel web access

We have SharePoint 2010 standard license in our organization, I would like to show an excel pivot table in "SharePoint Excel Web Access webpart" which belongs to the Business Data group of web parts, ...
1
vote
3answers
120 views

PowerShell script to download SharePoint attachments (Excel) with certain worksheet name

I'm trying to write a PowerShell script that will scan a SharePoint list and download an excel spreadsheet if it has a certain worksheet name. I'm not sure of where to start as far as syntax goes... ...
0
votes
0answers
17 views

Prevent “We're opening your workbook in Microsof Excel” message from being displayed

I have multiple environments with SharePoint solutions installed on them. Almost all of them are working fine except one that has an issue and don't know how to solve it. Each time I open an Excel ...
0
votes
0answers
48 views

Opening a SharePoint file using a hyperlink

On a browser-based SharePoint drive, the default file-opening functionality for an macro-enabled Excel file is to open it directly in Excel; no asking for Open/Save As, no intermediary steps; when the ...
0
votes
0answers
31 views

SharePoint 2013 form workflow in SharePoint designer export dictionary to excel

I am new to SharePoint and I am a little bit lost in here. I am in the SharePoint designer making a workflow, this one I'll export into visual studio and then deploy it, the problem that I have is ...
0
votes
0answers
12 views

How can I add the option for an end user to save an excel version of a Sharepoint 2010 table?

I tried taking the code from the button called "Save to Excel" in the top bar when editing but I'm trying to figure a way to allow end users on a site to download via a button on the actual page. ...
0
votes
0answers
33 views

Opening Hyperlinks inside Excel WebAccess webpart in the Same Window

I have the same question as in this link, but this solution is not working for me. $(document).ready(function() { $(".ewr-sheetcontainer a").each(function(){ ...
3
votes
2answers
27 views

Is Claims-based authentication Required for Kerberos and Excel Services?

I'm trying to setup Kerberos for Excel Services + SSAS. SharePoint Web Application pool using Classic Authentication. I was wondering if it's necessary to switch it to claims-based. I've found zero ...
0
votes
0answers
34 views

Dynamically change workbooks in sharepoint excel web part

I have created a custom ajax visual webpart that hosts an Excel workbook(say summary.xlsx) using ExcelWebRenderer class and i have LinkButton in the same webpart. My requirement is - when users clicks ...