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

learn more… | top users | synonyms

0
votes
0answers
14 views

Calculated column with Version data not refreshing, trying to export to Excel

I have a document library that I am exporting to Excel, and I am trying to output the Version number on the export sheet. The Version column is not available for export in Sharepoint 2010+ (we were ...
1
vote
1answer
50 views

how to export to Excel from a webpart

I am using Sharepoint Server 2010, and need to use OOTB features only. I have created a page with a web part on it, using a view from my list. The webpart works on parameters entered on the page. When ...
0
votes
3answers
47 views

Export mulltiple lists onto same sheet in Excel?

so I know we can export a single list to an Excel Spreadsheet, but is there a way export multiple lists on that same spreadsheet?
3
votes
3answers
33k views

Import Sharepoint List into Excel Using VBA Only

In Excel 2007, I have a VBA script that consolidates various data sources into a single Excel file for monthly archiving and reporting purposes. How can I import data directly from a Sharepoint ...
2
votes
6answers
18k 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 ...
0
votes
1answer
37 views

How to send automatically triggered mails from SharePoint with dynamically acquired Excel table data?

I am trying to figure out how to make a SharePoint workflow send a email containing specific Excel data from a file on this respective SharePoint. Maybe there is a far better way, i do not know. For ...
0
votes
0answers
42 views

Accessing files from SharePoint Library

I want to extract data from an Excel file stored in a SharePoint Library and dump the data in a SQL database. I have written different kinds of ETL processes in SSIS to achieve this with no luck. Here ...
2
votes
0answers
16 views

Synching select rows from an Excel spreadsheet into a SharePoint 2013 List?

I know you can connect Excel and SharePoint 2013, but is there a way to "selectively" sync data from an Excel Spreadsheet into a SharePoint List? Basically, we have a master spreadsheet where each ...
0
votes
0answers
11 views

Excel online cell contents follows the mouse when I move out of the cell

I'm quite new to SharePoint and I've been editing text in excel tables via the "edit online" function. I've run into a problem when clicking a cell and editing the text. Sometimes after I've edited ...
0
votes
0answers
15 views

Microsoft MDS with Excel SharePoint error

We are trying to use the MDS for Excel Add-in to have users concurrently manage data. The tool is working except when we load the Excel file into SharePoint (we are not trying to host the Excel ...
0
votes
0answers
17 views

Different sharepoint services available after joining farm

I have 3 tier server connected to sharepoint farm. The problem here is that, the third server (latest) that i joined to the farm has different set of sharepoint service compared to the other 2 ...
1
vote
1answer
91 views

Sharepoint 2010 Slow to open documents

Today users started reporting that they could not open Excel files located on our SharePoint site via IE. When a file is clicked, Excel launches and in the bottom a progress bar says "Downloading: ...
1
vote
1answer
105 views

Can not refresh external data in Excel file which connected to Postgres via PowerQuery in Excel Web App

We have an Excel file which is connected to a postgres database via PowerQuery. PowerQuery needs npgsql provider for it. When I open file locally on my computer and try to update data - everything is ...
0
votes
0answers
17 views

Problem connecting Excel sheet to Excel Web App

I am trying to Connect to Excel sheet in a SharePoint library using the Excel Web app and I am getting the following error, I have attached a screenshot for the same. Cannot complete this ...
0
votes
0answers
21 views

Newly Added Files Cannot be Opened from VBA?

I am using the following VBA code to open a file on SharePoint. This code works just fine for any other file on SharePoint but I cannot get it to work on one specific file. I recently added this ...
0
votes
1answer
9 views

Deleting SharePoint files via Excel

At work we have a spreadsheet of accounts that after a certain amount of time need to be deleted. So far the only way we have to do this is by manually going through each and every account and hitting ...
1
vote
0answers
167 views

SharePoint 2010 and Excel 2016 incompatibility

Situation: You check out/open a document or spreadsheet from SharePoint 2010 (Intranet) using the actual Office application (not in the browser). On attempting to save, you will either get a ...
0
votes
1answer
73 views

Extract a list to Excel

How do I extract a SharePoint 2013 list to Excel meeting this requirements? I cannot use SharePoint Designer. I do not want to use the export option as I want to be able to call this outside of ...
1
vote
1answer
107 views

Cannot edit column type or delete it in Sharepoint 2013

I have imported an excel file into SharePoint 2013. One of the columns I imported was PolicyType. It is currently set as a text field but I need to change it to a choice from a menu field. I don't ...
0
votes
2answers
3k 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
0answers
22 views

Cannot click on anywhere in Excel file opened in SharePoint 2013

I am unable to click on Menu Bar or Worksheet when I open my Excel file in SharePoint Server 2013. When I click, it just nothing happens at all. I am using IE. I don't think the problem is with ...
7
votes
2answers
352 views

Export to Excel adds  to currency field in sharepoint 2013

I am trying to export the data to .xls file using below code GridView2.DataSource = dt; GridView2.DataBind(); DirectoryInfo dir = new DirectoryInfo(@"C:\New List Reports"); ...
0
votes
1answer
167 views

SharePoint 2010 Excel xlsm file won't save to local computer

I'm having a problem troubleshooting an issue on SharePoint 2010. Users with Read only permissions via NT Authority/Authenticated users are having problems saving a local copy of a xlsm as a local ...
0
votes
2answers
368 views

Connect SharePoint Lists with OData

I have a DataSet, I have created an Excel spreadsheet using OData connection. Now I want to create a SharePoint List using this Excel data. I want the Excel and SharePoint List to be sync so that list ...
0
votes
0answers
55 views

Export to excel not showing all rows

We have a very large list and a user is exporting a filtered view to Excel, the view has 18,000 items, give or take, and he is only getting 16,000 items exactly I want to know if it is a problem with ...
1
vote
1answer
20 views

Doing calculations in Excel Online with user permission “View Only”

I want to share Excel files in a SharePoint library. The users shall only be able to open the files in "Excel Online", but not to download them or the open them offline. Also the original file ...
0
votes
0answers
89 views

export specific columns/fields of list to Excell and not the whole list. How?

End users doing export of list to Excel by going to List and choosing Export to Excel. Well this works fine, but the user wants only some columns to be exported not all columns. I've created "another ...
0
votes
1answer
29 views

Roles and analysis of results Excel Surveys

I have a excel survey created in a SharePoint page. Right now if I share the link, anyone can fill in the survey. Can I somehow restricted so that only users with an account on the intranet, or ...
4
votes
3answers
886 views

Is there a way to start a SharePoint workflow from VBA code?

I created a tool in Excel VBA that generates a custom report from the data I pulled from a SharePoint list via Excel VBA code. What I want to do is change/update the "Status" field for items within ...
0
votes
0answers
39 views

Save the modified date from sharepoint to sharepoint drive

I got this VBA Excel document where I map a network drive which is the sharepoint drive folder that I have admin rights for. The problem is that when people publish their document then the sharepoint ...
0
votes
1answer
39 views

How to Output Specific Columns to Excel

I have a custom application page that pulls data from one specific list and exports to excel. Below is the code that performs the work: <script runat="server"> protected void ...
0
votes
0answers
28 views

Create list with data from Excel files

I use SP 2013 and have a requirement to capture values from all the Excel files in SharePoint. All the files have different file names, but have the same sheets and need to refer to same cell in each ...
1
vote
2answers
9k views

query a sharepoint 2010 list from excel vba to retrieve a specific record

I have created a SharePoint 2010 list with 2 relevant columns: - Identification Key - Version Number I want to be able to query this SharePoint list from Excel VBA - passing the Identification Key to ...
1
vote
1answer
13 views

Different result in OData Assignments

Based on this question: msdn forum (it's my question too) I got different result OData in Excel 2013 and Browser. Excel give more result than Browser. My app use result from Browser, so some data ...
0
votes
0answers
25 views

SharePoint - saving excel library template

I have a requirement here which I would like to know if this is possible. Firstly I have setup a Document library to have a custom template which is in Excel. Basically its a financial template that ...
0
votes
1answer
58 views

How to export all list data from Web Scope to an excel file?

It would be greatly appreciated if someone can point me in the right direction on how to export all list data from a site to an excel file. Below is what the desired output should be. I've looked ...
1
vote
0answers
37 views

Auto reopen/refresh document

Is it possible to automatically reopen office document i.e excel sheet or word document from SharePoint? The documents are read only and I want a solution to refresh the document automatically when ...
1
vote
1answer
935 views

Import Sharepoint list via VBA in specific view

I am currenty trying to import a Sharepoint list in an Excel sheet via VBA and thanks to this: Import Sharepoint List into Excel Using VBA Only It is working pretty well, but if i leave the "VIEWNAME" ...
0
votes
0answers
201 views

Unexpected error occurred import excel spreadsheet

I am trying to use the Import Spreadsheet app. I do not have multiple versions of Office installed or multiple languages. I have followed this and it did not work: SharePoint 2010 error when importing ...
1
vote
0answers
159 views

Office Web App - Excel - Open in Excel

I have a very strange situation. I have a Excel 97 (.xls) upload in 2 different libraries. One library is in PROD and one library is in TEST. I can preview .xlsx without any problem. The problem is ...
0
votes
1answer
77 views

Excel connection. Issues with data getting into excel-table from SharePoint

I'm working on a project for a client. This client uses a form in SharePoint to enter and save data from certain projects into SharePoint lists. This data is setup to connect to an Excel file, that is ...
1
vote
1answer
61 views

Unable to open Excel documents on SP 2010 website

As of today one specific user is having issues opening Excel documents from a Sharepoint 2010 site. Whenever he tries to open one he gets the following error message. The screenshot is in Dutch but ...
0
votes
0answers
11 views

Create a sharepoint page to validate Excel data and then combine into 1 output Excel file

I have a situation where a dozen or so users send me Excel data. I have a series of rules to validate the data. I open each Excel file and apply the validation rules. If the file contains errors, I ...
0
votes
0answers
21 views

Data Entered in Browser View Does Not Show in Excel Document

Data has been entered into an Excel document by selecting "Edit in Browser" and then edit in the Web Apps. This data can be viewed when you select view in browser or edit in browser, but it does ...
1
vote
1answer
170 views

REST API Link to edit excel/word doc online

I am using the O365 REST API to display/organise files and currently xls/doc files have to be downloaded then opened in an editor in order to edit them. Is there a way to open these in the Word/Excel ...
0
votes
0answers
50 views

Does Excel Web Apps support xls format - SharePoint 2013 with OWA

I have a sharepoint 2013 with OWA configured . But it seems .xls files aren't supported. Is this true? If yes is there an alternative option?
0
votes
0answers
49 views

Problems editing Excel only document in a SharePoint library

I have several users with Contributor accesses to a library. One user can open and edit all word and power point documents, but cannot edit an excel document. All the others with same permissions ...
1
vote
1answer
123 views

Schedule a macro in an excel saved in Sharepoint 2013

I have an excel file with a macro that I would like to run twice a day automatically. The file is shared in a Sharepoint 2013 site. Is it possible to schedule this macro? Thanks!!!
0
votes
1answer
223 views

Unable to refresh data from sharepoint list in excel services

I've a SharePoint farm with Excel Application Services configured. I've created a Excel workbook with OData connection to SharePoint list. In Excel web view, I can't refresh data. Need help !
0
votes
0answers
26 views

Sharepoint List to Excel Update Excel Webpart

I have a list that is over the 5000 view threshold. The thought process was to export this to an Excel file, run Pivot Charts and then show the charts on a SharPoint Page using the Excel Webpart. ...