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

learn more… | top users | synonyms

2
votes
1answer
63 views

From Excel 2010 is it possible to attach a PDF file to a list item.

I have the list item ID and I have the location of the PDF file, it is created using the excel sheet and now I want to attach it to a list item.
3
votes
1answer
95 views

how to export BI report to excel

We deployed bi dashboards in our web application using the performance point service and it enable annonymous acess for users without login they can view. but when they trying to export it ask ...
3
votes
1answer
52 views

Can you prevent Excel for adjusting column widths when doing an export from sharepoint?

My list and reports are fairly large. Now that I have converted the MS Office 2013 I've noticed everytime I try to do an export from my SharePoint lists even a small export it takes a long time to ...
0
votes
0answers
19 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
68 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
90 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?
0
votes
0answers
71 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
12 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
18 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 ...
0
votes
1answer
68 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 ...
1
vote
1answer
1k views

Can't open office documents from SharePoint site

I'm using SharePoint 2013 and some users, I'll repeat, only SOME of them can't open office files in their client application (word, excel...). I don't know what is the problem because I can open ...
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 action. ...
0
votes
1answer
126 views

How to delete a row from an Excel Table using the client-side Ewa object in a SharePoint Excel Web Part

The SharePoint Excel Web Part client side API ,Ewa (https://msdn.microsoft.com/en-us/library/office/ee589018.aspx) does not seem to have any methods to manipulate an Excel Table (i.e. a ListObject in ...
0
votes
0answers
23 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
1answer
166 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 ...
1
vote
0answers
222 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
80 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
232 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
0answers
24 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 ...
0
votes
1answer
208 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
0answers
67 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
109 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
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
136 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
38 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 ...
0
votes
0answers
43 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 ...
2
votes
2answers
779 views

How to save a list in a csv file via Powershell

I have a SharePoint online list with more than 9000 items and 22 column. The list is being populated on daily basis. I am taking backup manually every morning by saving the list as excel file in the ...
0
votes
1answer
52 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 Page_PreInit(...
0
votes
0answers
31 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
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
29 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
69 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
44 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 ...
0
votes
0answers
302 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
180 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
148 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 ...
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
232 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
65 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
69 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
186 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
338 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
31 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. ...
0
votes
0answers
45 views

Synchronize Excel 2013 to SharePoint 2013

I tried several ways to synchronize an Excel 2013 sheet to SharePoint 2013. For example download and see this MS Add-In It works once, but I got a problem report after saving the sheet and trying it ...
1
vote
1answer
74 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
123 views

Excel charts do not refresh on Sharepoint

It seems that the charts in Excel webpart do not refresh on Sharepoint if the series of the chart are connected to some named formulas / UDFs. It seems that anything beyond a simple name connected to ...