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

learn more… | top users | synonyms

1
vote
0answers
20 views

Is it necessary to configure Excel service application and secure store to view excel reports in SharePoint?

We are using SharePoint 2013. Now we need to add some excel sheets and excel reports onto the SharePoint page. So we have seen that there is a Excel viewer webpart. I was wondering whether it is ...
0
votes
0answers
15 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
22 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 ...
4
votes
3answers
3k views

Filtered SharePoint List for Export to Excel

I have an Issues List is SharePoint that contains over 75 different categories. I would like the ability so that when I use the filter on the column title and select a particular category, that then ...
2
votes
4answers
12k views

Export Survey Results to Excel option not in Action Menu

I have a survey and all the needed results. I need to export the results to excel, though in the process of setting up the survey I changed or removed the Overview.aspx page/view. Now when I add a ...
8
votes
9answers
35k views

Update Sharepoint list using excel

I have a SharePoint that has list and I need to be able to update this list with new values from an Excel sheet (using VBA). This can be done from Access not a problem however I need it to be Excel ...
3
votes
2answers
37 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 ...
0
votes
1answer
5k views

Import Excel Sheet and append items to SharePoint list [duplicate]

I have Excel sheet and existing SharePoint list (Import spredsheet app) on my SharePoint server. We need to append the data from the new excel sheets to the existing lists items of the SharePoint ...
2
votes
1answer
48 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 ...
3
votes
0answers
149 views

Cannot Open Excel sheet in web-browser

I am having a problem opening the excel sheet in web browser, it throws an exception.. Excel Web Access >> An error has occurred. Please contact your system administrator if this problem ...
6
votes
2answers
253 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 ...
0
votes
0answers
14 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
64 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 ...
5
votes
1answer
173 views

Can someone help me use SharePoint 2010 to do data processing?

TL;DR: I need to create a system in SharePoint in which a user uploads an Excel (or CSV) file to the site from a webpage. The site takes the uploaded document and uses it to populate a list. Then it ...
1
vote
1answer
53 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 ...
8
votes
7answers
34k views

Unable to open office files in Office client

While trying to open an excel document stored in "Shared Documents" library, the excel application opens up with a login prompt, to which I passed the login credentials of the site. After which the ...
0
votes
1answer
42 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
23 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
14 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
19 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 ...
1
vote
4answers
9k views

Export to excel - large lists

I am having when Exporting large lists to excel (over 14K records). It displays “Running security Scan” at the bottom of the screen and then gives “An unexpected error has occurred. Changes to your ...
3
votes
4answers
35k views

Excel document opening in browser (unsupported features)

I am using Sharepoint 2010 and when users click on an .xlsx document in a document library it says the following: "The workbook cannot be opened because it contains the following features that are ...
0
votes
0answers
46 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
20 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
2k views

SharePoint 2013 Excel Services & External Data Refresh Failed

I need advice how I can fix problem with Excel external data connection. I have an excel file, which have connection to SSAS. Excel file "refresh all" works fine if I download it out from SharePoint. ...
1
vote
1answer
44 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
6 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
95 views

Excel file which have macro enable not opening in IE

I've a requirement in which an excel file( Macro Enabled) is stored in SharePoint 2010 and when user clicks the file, it should open in the IE as read only file. The Excel file is opening in the IE ...
0
votes
1answer
39 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
39 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
28 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
24 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
78 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 ...
2
votes
1answer
2k views

Can't open excel file in edit mode, currently open by 256 users

I got an issue from one of my users, where he would get the following message whenever he opened a particular excel file stored in a document library. The workbook is currently open by 256 users. ...
0
votes
2answers
84 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 ...
1
vote
1answer
21 views

Cannot find (Excel Services Application & Visio Graphics Service ) inside the Service Application Menu

I have installed a new SharePoint server , and I wanted to create a new Visio graphics service and Excel service application, so that users can view excel & Visio documents inside their web ...
0
votes
0answers
57 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
65 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
15 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
69 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?
0
votes
1answer
102 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 ...
1
vote
2answers
100 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
2answers
171 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 ...
3
votes
5answers
46k 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
0answers
36 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
0answers
44 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
18 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
35 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
62 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 ...