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

learn more… | top users | synonyms

0
votes
0answers
10 views

COUNTIFS function in SharePoint List

I have challenged myself to create a list where a list or library's columns and data are exported automatically into a Excel Workbook or web-part, then evaluated via COUNTIFS to read multiple columns ...
3
votes
1answer
64 views

Open new item direct with excel

I am using O365 SharePoint and Create a WebPartContentType with an Excel-Template. So when you click on "New Item" it open the Template with Excel-Online. Now my question: Is it possible to open the ...
0
votes
3answers
90 views

Are there list view url parameters to export to Excel?

I would like to automatically export a list view to Excel as a single click process. Are there parameters I can add to the list view url that will accomplish this? The list view is currently provided ...
2
votes
2answers
161 views

Use a workflow to filter a list

I have a spreadsheet that contains numerous products, each one with a unique PN, desc and price. There is similarity between products, contained in additional columns with simple YES or NO values ...
1
vote
2answers
81 views

Convert list data to excel and upload it to document library without downloading

I have a requirement to export my list data directly to document library as new Excel document. I have used the following code to export to excel function getLists() { context = new SP....
0
votes
1answer
130 views

Anonymous Users cannot open XLSX/PPTX files from a SharePoint 2010 document library

Scenario :- Environment :- SharePoint 2010 we have a Site Collection and sub-site which has complete Anonymous Access and all the Document Libraries under the sub-site are given View Items ...
0
votes
0answers
25 views

Missing columns when extracting list via VBA

I'm trying to extract a list from a corporate Sharepoint using VBA, but a key column does not get extracted. When I Export to Excel from Sharepoint, the column does get extracted. But I want to be ...
3
votes
1answer
14k views

Documents open read-only when user should have write access

Scenario: We have an internal application that ties Excel spreadsheets stored in a SharePoint doc lib with specific Opportunities in CRM. The user clicks on a button in the Opportunity and a Web ...
1
vote
1answer
45 views

Can SharePoint view in browser docx/pptx/xlsx taken from external sources?

I've noticed SharePoint project (2013 atleast) can view in browser Excel, PowerPoint, and Word document files, which is great. So when you create an html5 web app on SharePoint, you can link the docx/...
0
votes
2answers
27 views

Hyperlinks in Excel are changing when uploading to SharePoint document library

I uploaded Excel files from an external drive to SharePoint document library. The hyperlinks in the Excel spreadsheet works fine in my local, I can open the links. However, when I uploaded it in ...
0
votes
1answer
11 views

Customized Write Protection of Excel Forms on SharePoint

I have excel files on a SharePoint site which I am linking to the company's intranet. The reason we have the forms on SharePoint is that certain people need to update the forms regularly and we want ...
3
votes
2answers
10k views

Is there a free sharepoint hosting site where I can try out Access 2013 asset tracking template?

Is there a free sharepoint hosting site where I can try out Access 2013 asset tracking template? I just want to see how it works.
3
votes
4answers
55k 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 ...
0
votes
1answer
37 views

User issues when opening the owssvr Exporting a List to Excel

I have created a List and Exported that list to Excel via owssvr. I have one User in our 15 person group that when she opens the owssver. One of the columns is supposed to show Last Name, First Name. ...
0
votes
0answers
9 views

Excel Online Office Add-In as a Service

In Google Sheets, using Apps Scripts, we can have a spreadsheet run as a service. We can write doGet and doPost methods in Apps Script which allow to handle HTTP Requests. Is this possible in Excel ...
0
votes
0answers
7 views

Excel Embeded View Editable fields?

I know how to embed excel on page so that users can see the data. I want users to be able to input updates on the page excel embed rather than opening the excel file. Is it possible?
0
votes
0answers
35 views

SharePoint App - How to Create/Populate Excel Spreadsheet Using JavaScript and List Data

I'm trying to create a Excel spreadsheet on a SharePoint app/add-in. The data that will populate it have been gathered from several SharePoint lists on the host web. Right now, I'm able to interact ...
0
votes
1answer
39 views

Hyperlink to Excel file in SharePoint Online: How to set by default that file opens in Excel (not Excel Online)?

I have put a hyperlink to an Excel file in our SharePoint (Online) to my company's intranet. How can I manage the file opens by default in Excel, not in Excel Online? Excel Online does not support ...
0
votes
0answers
24 views

Retaining the document version with “Export to Excel” delivers a runtime error

We have been working for a kinda long time now with a vba script for retaining the document version in an exported Excel spreadsheet. It was working pretty well, however, since a few days it delivers ...
0
votes
0answers
24 views

Hiding list items

In SharePoint 2007, I was able to create a column to hide an line in an Excel spreadsheet that was loaded into SharePoint. I cannot locate this option in SharePoint 2010... (we have not yet updated ...
0
votes
0answers
12 views

SharePoint Date not functioning in Excel?

I have a SharePoint list that has been exported into Excel as a XLSX file. When it is first exported, the SP date works great with Excel. I am in need of converting it to a column for month, quarter,...
0
votes
1answer
25 views

Set Office Web Apps as a WebPart in SharePoint 2013

Currently, I am using SharePoint Foundation 2013, and I want to config like the link below, but in foundation version, I cannot see "Business data\Excel Web Access" So I setup Office Web Apps, but ...
0
votes
0answers
23 views

SP2013 - Excel two way sync

So I've been asked to create a setup where the user can copy a rather large amount of info into an Excel file and then have it synced to the connected SP list. I've found several articles about the ...
3
votes
3answers
10k views

SharePoint 2010 error when importing excel spreadsheet to sharepoint list

I get the following error when trying to import an excel spreadsheet into a SharePoint list. "The specified file is not a valid spreadsheet or contains no data to import" I have added this site to “...
0
votes
1answer
52 views

Is there a way to get an Excel doc that uses a visual basic feature to show in SharePoint?

.com/GNU92.png First image shows the blue filled in date sections in the Excel doc. This is the desired display format of the doc. Second image shows what is displayed in SharePoint. No blue date ...
4
votes
3answers
3k views

Link on wiki page to Excel document that opens in Excel Online

On a wiki page, I would like to create a link to an Excel document stored in the Documents folder on SharePoint, that opens the Excel file in Excel Online. When I create the link using Insert -> Link ...
0
votes
2answers
28 views

Excel->SharePoint

So I have a huge excel spreadsheet, with multiple lists and columns, how would I incorporate this into my SharePoint website as a new link? I know how to add an app, etc...but how do I add the ...
0
votes
2answers
141 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 ...
0
votes
1answer
21 views

excel upload with only specific columns

I'm trying to upload an Excel file to SharePoint, but i would like to only upload columns AL, B, and AU, and wondering if SharePoint has a way to do this, or if Excel has a way i can upload it to a ...
0
votes
1answer
24 views

SP - When click buttonToExcell page stay blocking

My problem is, where i click a button for export in excel, all buttons in my page not working, when refresh everything is okay. This is my code for btn to excel: oid btnToExcel_Click(object sender, ...
0
votes
1answer
23 views

SP - Foreach Gridview cells before export in Excel to change TextFont

I want to change text in gridView cells before export in excel, because the text is big after export. This is my button to export in Excel: void btnToExcel_Click(object sender, EventArgs e) { ...
0
votes
1answer
68 views

Workflow for sending email in SharePoint 2010

Is there any way to get an excel export from a SharePoint list and email to users in SharePoint 2010? We have a list which update weekly and I want to email all users in format of Excel
0
votes
0answers
13 views

How to build data connections across multiple Excel reports on SharePoint into a single file?

I have a dozen or so excel reports hosted on SharePoint in a template format, and I am trying to aggregate all of that information into a single master report. Because these files are on SharePoint I ...
1
vote
0answers
117 views

Create sharepoint document folder using VBA

I need to find a way to programmatically, using Excel VBA, create a folder in a Sharepoint Document Library. The Sharepoint Document Library already exist, and it has already one level of folders in ...
0
votes
3answers
50 views

Excel 2013 to Sharepoint List

How do I Insert, Update and delete Excel file to SharePoint lists. Automatically it has to create columns that are present in Excel sheet & whenever we add a record, update a record or delete a ...
0
votes
0answers
17 views

Is it possible to enter excel property easier for a new sheet in a document library?

I have a document Library (with only excel sheet) with the option of creating a new doc with a Template. The other property of the list consist of the title, a choice and a lookup on a list. When I ...
5
votes
3answers
24k views

Update List from Excel using VBA

I'm in the enviable position of having to support a client who wants to maintain and manipulate a complicated business spreadsheet in Excel, and then push a selection of that data to a list in ...
0
votes
0answers
51 views

SharePoint Online Export to Excel

When I export a Multi-line (enhanced rich text) column to Excel a line-break gets appended before the content. This makes it looks like the column is empty in Excel until user clicks on the column ...
4
votes
4answers
22k 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 ...
0
votes
0answers
35 views

Custom Document Information Panel works for Word, but not Powerpoint or Excel

I receive an 'unable to load form' error from my custom document information panel when trying to save an Excel or Powerpoint file into a SharePoint library. However, there is no error when I try to ...
0
votes
1answer
97 views

Open File in a Sharepoint list via VBA

I want to open an excel file in a Sharepoint list via VBA. Here is my code: Sub OpenWB() Dim SummaryWB As Workbook Dim vrtSelectedItem As Variant With Application.FileDialog(msoFileDialogOpen) ....
2
votes
2answers
773 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 ...
2
votes
2answers
3k views

How to import MS Excel data into an exisiting SharePoint List?

Is it possible to import an excel list or excel data into a SharePoint List that has already been created? Not create a new list. I know you can import a spreadsheet which will create a new list, but ...
1
vote
2answers
2k 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 ...
0
votes
1answer
140 views

VBA code to determine whether a SharePoint file is checked out?

I've written a VBA program to examine each Excel workbook in a SharePoint folder and perhaps move it to another location. It turns out that rarely (but not never) a user is currently editing a ...
0
votes
1answer
20 views

Import Spreadsheet with field name listed vertically/per row

I need to import a spreadsheet, but the field names (title) are listed vertically. Is there any way I can import it? e.g. field 1 | axy field 2 | 30 field 3 | ax21
0
votes
1answer
131 views

Programmatically read Excel file in SharePoint 2013 sandbox solution gives permission error

SharePoint 2013 server, I'm site collection administrator. I've copied an Excel file into documentlibrary, I like to read the excel file and update custom list with the Excel values. I've got the ...
1
vote
1answer
333 views

sharepoint - accessing excel files from VBA

I'm trying to access SharePoint directory from Excel VBA and loop over all files at this directory. But when I try to refer to the directory, then I get this error in return: Path not found I ...
0
votes
0answers
32 views

SP2010 - Cannot Open (Certain) Excel Files in Browser

I have an odd problem. I have two reported issues from users on two separate site collections (same webapp). In both cases, CERTAIN excel files that previously opened in the browser, no longer will - ...
1
vote
4answers
14k views

Export list with attachments

We have a legacy Sharepoint Services 2.0 server where users have been maintaining a few custom lists. There are items in these lists that have attachments (Word, Excel, PDF type documents). Over the ...