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

learn more… | top users | synonyms

0
votes
1answer
57 views

How to save a ExcelBook generated using ExcelTemplate on SharePoint2013 Cloud

wbook.SaveAs("c:\\temp\\blah", Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookDefault, Type.Missing, Type.Missing, false, false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, ...
0
votes
1answer
118 views

How to work with Excel in c#?

I have a template/format in excel which has to be used to generate salary slips. I have saved it in a document library and using interop, open an instance of it in a workbook programmatically. After I ...
0
votes
1answer
100 views

Populate an excel object with List entry items

I have a requirement that requires generation of an Excel document programmatically in SharePoint. I need to use an Excel template that has labels like Name: Designation: Email: I have a list with ...
1
vote
1answer
421 views

Importing values from a SharePoint Calendar to Excel form

My company runs EMS Service for private parties, sports events etc. We are scheduling our tasks with a SharePoint calendar. For each event one has to create a Excel sheet containing time, date, task ...
4
votes
2answers
2k views

Retrieving list items from multiple sites via OData with Excel

I want to build a report: with Excel 2013 + PowerPivot Add-In using data from SharePoint Online that should work in Excel Services (so I'm not able to use VB, Power Query, etc.) Report should be ...
0
votes
0answers
22 views

SharePoint 2010 Workbook cannot be open in Chrome [duplicate]

The Workbook cannot be opened because it contains the following features that are not supported by excel i n the browser: Data validation Sheet Protection I'm trying to open excel document in ...
1
vote
1answer
68 views

Read excel data from attachment and display in SharePoint and allowed to edit

User would like to upload a excel file into SharePoint and he expect system to read his file and display out the data that he have uploaded in SharePoint. Besides, from SharePoint, he requested to ...
0
votes
1answer
538 views

Excel Online - Enter Array Formula

In Microsoft Excel entering an array formula requires using the keyboard combination: Ctrl Shift Enter How can I enter an array formula in Excel Online (the WebApp version of Excel). Is there ...
0
votes
3answers
759 views

Can we create Excel file using c#?

I would like to know if it is a good idea to create an excel file using c# in sharepoint? I've tried to find js libraries but despite ExcelBuilder which seems really complicated to use i can't find ...
1
vote
0answers
2k views

Unable to check-out an excel sheet from a document library in SharePoint 2010 Standard

I have a document library under my SharePoint 2010 Standard site. We are uploading Excel files to this document library to be updated by multiple users (Using Check-in/Check-out). We are using IE9 as ...
0
votes
1answer
150 views

Imported Excel Spreadsheet not Filtering Column

I am uploading an excel template to the SharePoint site. I have 8 different metrics and want to add a filter to a specific column.SharePoint automatically adds the filter option to certain columns, ...
1
vote
1answer
404 views

Prevent User saving excel document back to Sharepoint

I have users on Excel 2010 and they are accessing a sharepoint site using Sharepoint Services 3.0 and clicking on the excel document and the default behaviour is to save this back to sharepoint rather ...
0
votes
1answer
265 views

Filling SharePoint Calendar List With Bulk Data(About 3000 Entries)

I want to fill about 3000 entries in a SharePoint calendar List for testing purpose. I have tried using this link but i have some lookup columns and person/group fields which do not appear in the ...
0
votes
0answers
1k views

Read excel file from sharepoint document library in office 365 programmatically

I have one excel file uploaded in document library of office 365 site.I want to read this excel file using c# as we read in farm solution using following code. using (SPSite site = new ...
1
vote
3answers
4k views

Unable to Refresh the Excel Connection in Excel Webaccess Webpart

I am using an excel workbook with pivot in it. I am using the Excess webpart to display it. As I click on the Refresh all data connection. It throws an error.The scree shot is attached. I have ...
1
vote
1answer
126 views

Filter Sharepoint 2013

I have a customer who asked a very difficult requirement and do not know if possible. It uses excel but all migrated to sharepoint, and there is a filter in excel there is a text field to write and ...
0
votes
1answer
38 views

Faster way of Downloading Metadata in CSV

we Have document library with 3lacs+ items. we have to download metadata of each file in a csv such as Modified date , modified By etc. I used powershell code for achieving this task but for some ...
0
votes
2answers
1k views

Rich Text field in Infopath customized form adds blank lines in Excel

I have a fairly basic custom list in Sharepoint 2010 which contains a rich text field. I have customized the form with Infopath. Now when I export to Excel I find blank lines preceding the text. ...
2
votes
1answer
531 views

Excel files are not previewed in office web apps

I have a document library with 10,000 excel files all the files have some macros for calculation in Sharepoint 2013. When I search on that site collection, sometimes I get a preview, sometimes I ...
3
votes
2answers
512 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 ...
1
vote
1answer
334 views

Since last patch, unable to open excel documents and word documents can only be opened by dropdown

We performed updates to the SharePoint Portal, SharePoint Foundation, Office Sharepoint Server, Excel Services Component, and Word Server on 03/16/2014. Since then, we are unable to open Excel ...
1
vote
1answer
776 views

Excel document not updating on open

I have an excel document that is linked to a SP 2010 list. I set the connection and the update on open. It works just fine (i.e. updates with new data) when the file is on my local machine. However ...
0
votes
1answer
72 views

Setting to enforce use of Excel Services rather than Excel Web App

Our site and sub-sites are defaulting to Excel Web App rather than Excel Services. We require Excel Services. I think maybe I hit a setting somewhere at the root which has caused this change. Where ...
3
votes
4answers
7k views

Error - while exporting a Sharepoint List (Export to Excel)

Colleague of mine is facing the below issue while trying to export the SharePoint List which has more than 10 000 items. However I was able to export the complete List without any issues. Note: He is ...
3
votes
3answers
17k views

How can I share an excel document with my team to edit?

I would like to know if something is possible and where to start. Each day, my boss sends out a spreadsheet listing our data entry errors for the previous day. All five of us download the sheet, make ...
1
vote
0answers
404 views

Issue with Office Web Apps - can't open Excel file, prompt for user name and password

I can't open by Office Web Apps Excel file, SharePoint always prompt for user name and password and after entering correct user name and password it happens again and get error: "An error has ...
1
vote
4answers
14k 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 ...
1
vote
0answers
31 views

Sharepoint Online 365 and refreshing excel files

Is there a way to have the excel files refresh their links hourly or daily?
1
vote
1answer
848 views

How to import excel spreadsheet to SharePoint document library?

Excel spreadsheet has several columns including a filename column which has actual path to file, that file should is exactly I want to be imported to document library. Once imported the filename ...
1
vote
1answer
154 views

How to create an Excel Document when adding a Library Item?

Hope you can help me with this question: I have a SP Library, where the user should type info into some fields (Text, Publishing HTML, Datetime). So, I'm wondering if it's possible to use that info ...
1
vote
1answer
57 views

Windows 7, excel and word 2010 how get RID of Sharepoint popup window? [closed]

When using Excel (and possibly Word) this irritating popup window appears requesting some kind of password. I want to get RID of this window and get rid of Sharpoint, whatever it is.
0
votes
1answer
110 views

Collect data from SharePoint and make from that a report

I want to create a report , the data source will be a SharePoint list . I tried to use the PowerBI (unfortunately , its configuration is not going so well) , then I thought about Excel (a combination ...
0
votes
3answers
6k views

Import Excel to SharePoint list -> Auto-synchonize based on Id

Are there tools available for importing an Excel file to a SharePoint list so that the importing data would be synchronized based on specified field(s)? I would mostly be interested in a ...
1
vote
1answer
43 views

Port change from 80 to 443 causing endless user prompting when accessing office files

This weekend I changed the main web application to run on https instead of http. This morning when some (not all) users try to check out or edit and office file they are continually prompted for ...
0
votes
2answers
1k views

SharePoint list not accepting copied excel data

Hello I am having an issue with a SharePoint list not accepting copied data from an excel sheet while in datasheet view. The sheet has 130 rows of data I have done this before and made sure the ...
1
vote
1answer
3k views

can we make it “export to spreadsheet” in sharepoint list automated?

my client wants it automated so that the exported csv file will be saved periodically into a location and he can do his necessary action. rather than coming into the site and exporting it each time. ...
0
votes
1answer
216 views

SP13: Overwriting Excel Importing List

This task seems easy, but is turning out to be more complex than I expected. I have a excel spreadsheet that I have imported into a custom list. In order to import the excel spreadsheet by using ...
1
vote
0answers
52 views

code for redirecting to a page from a link in excel

I have an application where all my list data is getting exproted to excel. In excel there is a link in a column. On clicking that link it should redirect to a page form excel. Require c# code for that ...
3
votes
1answer
4k views

How to export speific rows of a list to excel (using OOTB)

I need to create a list with "Export" as a column. (Export column should be a hyperlink field). Once user clicks on "Export" field value, then that specific row data should get exported to excel 2010. ...
0
votes
2answers
2k views

Import File from SharePoint and Link this file with SharePoint (File- Excel File)

I am using SharePoint 2013 and Microsoft Office 2007 or above. Scenario: I upload a Excel file to a SharePoint 2013 list. Now, I want to import this Excel file from this SharePoint list back to ...
0
votes
1answer
102 views

SharePoint 2007 - Users losing data in excel files

We have a SharePoint 2007 in our environment and our users are reporting that they will make changes to excel files and will go back the next day and the changes will be gone. This happens randomly ...
0
votes
3answers
164 views

How to export list items in same order in a list to excel 2010 (console application)?

I require to export list items from a SharePoint list to Excel. The order of items in the Excel sheet should be the same as in the list. Can somebody suggest console application code for this?
1
vote
1answer
509 views

Compare Date to constant using ACE.OLEDB.12 in Excel VBA [closed]

After a lot of searching, trial and error, I finally managed to come up with an Excel VBA procedure that will return date from a SharePoint list. The query works fine if I do not qualify the Select ...
3
votes
1answer
4k views

Cannot Edit Excel Document with Full Control Permission

There is a document with permission. User A and User B can only edit the document after they open from sharepoint. User A has Excel 2013 in his PC. When he opens it in Excel it says "The document is ...
0
votes
1answer
353 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 ...
0
votes
1answer
110 views

Get Chart web part to dynamically change with original share point list

I have a sharepoint list that contains a list of projects and their technology. Example. P1 - Java P2 - SAP P3 - Oracle P4 - Java p5 - Oracle I want to be able to represent the Tech distribution ...
2
votes
1answer
1k views

Thumbnails/snapshots don't show in PowerPivot Gallery when the document refreshes on open

I have several excel documents containing PowerPivot tables. They all connect to a SSAS Tabular service (on SQL 2012) via a .odc connection file, all of which is hosted on SharePoint 2013, using the ...
1
vote
2answers
224 views

Merging excel documents similar to slide libraries

I have a scenario that would be perfect for slide libraries - but they're excel sheets. We use SharePoint 2010. Also, I do not have access to the server itself... Just site collection administrator. ...
2
votes
1answer
367 views

Cannot retrieve all items from large SharePoint list via Excel data connection

I have a large SharePoint 2010 list (~60,000 items) in which the list view threshold has been turned off. Recently, we've encountered the problem that exporting the list to Excel only yields a subset ...
0
votes
0answers
78 views

How to synchronize an excel spreadsheet with SharePoint 2010?

I have a spreadsheet being fed by several SQL Queries. After the queries are run, the fields repopulate and I have Graphs/Charts and formulas that visually display the data. I'm trying to simply ...