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

learn more… | top users | synonyms

0
votes
1answer
77 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
162 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
367 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
187 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
567 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
63 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
118 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
35 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
945 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
40 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
48 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
30 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
10k 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
28 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
64 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
42 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
1k 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
266 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
174 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
114 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
71 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
196 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
54 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
57 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
158 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
283 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
30 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
2answers
351 views

Cut and Paste not working in Datasheet view Sharepoint 2013 O365

I have a question regarding an unusual error that I can't seem to resolve. I have a document library and am trying to cut and paste metadata from an excel 2013 spreadsheet into columns in a datasheet ...
0
votes
0answers
44 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
4answers
18k views

Import from Excel to an existing list

I'm trying to import data from excel into an existing list. I can paste one line at a time by opening the excel doc and the sharepoint list in datasheet view, but that's not very efficient. Any ...
0
votes
2answers
454 views

Synchronize excel file with SharePoint online list

I want to synchronize data from excel file with SharePoint list on office 365. I have already built a utility which uses client object model to achieve this but it is very slow as item count are in ...
1
vote
0answers
73 views

Editing sharepoint online list in Excel

For some reasons I want to edit my SharePoint online list in Excel 2013 spreadsheet. What are the possibilities?
1
vote
1answer
1k views

Most “full control” users can't access datasheet view or export to Excel

All but the administrator users with "full control" and/or "contribute" permissons on a certain list do not recieve the datasheet view option, and when they try to export to Excel there is a ...
0
votes
2answers
682 views

Mail Merge with Excel Document stored in SharePoint

We have an Excel Document we would like to use as a source file for a Mail Merge in Word. When we open the Excel file in the mail merge wizard we receive the following error. "Sorry we couldn't ...
0
votes
0answers
114 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 ...
3
votes
2answers
335 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 ...
1
vote
1answer
16 views

Excel Service Not Work after Import an Exported Application

my Excel service is not working.My Excels opening in my Client MSExcel but not open in Browser.its happen after after my application has problem and I have to Export and import again to work fine....
0
votes
1answer
17 views

importing excel onto sharepoint and use the data to build reports?

Is it possible to do this with sharepoint? I have read quite a few introductory articles that seems to hint on the possibly of acheiving this, but I couldn't find any tutorials on it. Can someone ...
2
votes
2answers
7k views

SharePoint List Export to Excel All Columns!

As you may know SharePoint's default export to excel only exports the columns of that current view to excel. Is there anyway to export all columns, without adding all columns to that current view.
0
votes
0answers
108 views

Office Web Apps + SP2013: Why is only Excel opening in browser by default?

I just installed Office Web Apps and configured it to SharePoint 2013, but only Excel seems to open in the browser by default. Word, PowerPoint, PDF etc. opens in client application. Preview works ...
0
votes
0answers
36 views

“This workbook cannot be opened…” on 64bit IE

So, The message when trying to open an excel file from SharePoint goes like this This happens when I use IE, specifically the 64bit version. If I use the 32bit version, it runs fine. Now, this is ...
1
vote
2answers
934 views

Using Chrome to Open an Excel Workbook

I thought there was a way to manage ActiveX extensions on Google Chrome, specifically one that manages how Chrome handles Excel workbooks when you click on the hyperlinked title in SharePoint. Is ...
0
votes
0answers
39 views

Sharepoint Mutiple Lists, Excel import & export questions

Here are a few questions i have regarding SharePoint & Excel - Using 2010 I have created a list that is an "Order Intake Forum" It asks the user various questions in order to place an order &...
0
votes
1answer
19 views

Who has precedence?

If there's only one user who has "can edit" permission and he has it open on his Desktop, do his changes over write what a "can view only" user is seeing in Excel Online? When would the viewer see the ...