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

learn more… | top users | synonyms

0
votes
0answers
9 views

how to use Lists.addattachment method to attach a file to a list item using excel 2010 VBA

I have tried the method from msdn microsoft site , but I may need an example in excel VBA. The post from excel 2010 is it possible to attach a PDF file to a list item is not explaining any ...
0
votes
1answer
17 views

Import interactable Excel document

Is there a way to import an Excel document to a sharepoint list that is intereactable just as it would be in Excel? I've tried but the functions wouldn't follow with the list to sharepoint, only the ...
0
votes
0answers
11 views

SharePoint 2013 and Excel 2010 - This workbook was opened from a server in read-only mode

Users are getting the error as " When users click on Edit, they get the following error: Users cant edit the spreadsheet. I already checked the permissions and permissions are fine. I already ...
0
votes
2answers
27 views

Track SharePoint Changes

I have made a view in my SharePoint from an excel file and want to track the daily/weekly changes. How could I set up something to send out an email weekly to notate what changes were made and what ...
1
vote
2answers
32 views

Unable to Export to Excel

I am attempting to export a list of files and their metadata into excel 2010 via internet explorer, the file is created and appears to download normally but when opening the excel window it freezes ...
0
votes
0answers
15 views

Live chart using SharePoint Excel Webpart

I have a list on SharePoint online. What I am doing right now is, exporting the list data into an excel file. And then created some charts in that file. To display the charts on a sharepoint page, I ...
0
votes
0answers
8 views

SharePoint to Excel Formula Deletion

I keep having an issue when I open a document that pulls data from a SharePoint site. Once I refresh the connection in excel, the formula that I have inputted into a column in excel disappears? Anyway ...
1
vote
1answer
21 views

SharePoint Date Formula

Let's say you have a date formatted as 31/Dec/16 but wanted to calculate two cells over to show 201612. How would I put in this formula because excel and sharepoint do not have it already formatted in ...
0
votes
1answer
13 views

Configuring Co-Authoring in SharePoint 2013 site collection?

How do I configure Configuring Co-Authoring for SharePoint 2013 site collection for MS Word or Excel documents?
0
votes
0answers
6 views

Sharepoint removing Excel text boxes

I have a number of Excel workbooks with text boxes that I place into Sharepoint folders. When downloading those files from Sharepoint the text boxes have been removed. Is there something I can do to ...
0
votes
0answers
11 views

How to open a Excel file containing macros in Browser? Also Allow users to co-author the excel file

How to open a Excel file containing macros in Browser from sharePoint document library? Also Allow users to co-author the excel file
0
votes
1answer
18 views

Is it possible to use a custom .xlsm file as the template for a document library?

I have a macro enabled Excel spreadsheet (.xlsm) that I want to use as a template for a form library. I want to know whether it is possible to do so? If not, is there any other way I can make all the ...
1
vote
0answers
23 views

Person lookup in Excel metadata field crashes

I have SharePoint 2013 Foundation and I open Excel 2013 from Document Library, which has serval metadata fields, including Person Lookup. Now, when I press Address book icon at Excel metadata bar, ...
1
vote
2answers
36 views

Export all lists to excel

I have three different list seperated by Area (NY, NJ, and CT) is there a way to build a report in the database that will pull all records from all lists? I exported all three to excel one by one, but ...
0
votes
1answer
32 views

SharePoint 2013: Excel Import Issue

I'm importing an excel list with many columns, but one of the columns is unable to be used in a lookup table. The column contains the multiple owners for the main object and sharepoint can't read it ...
3
votes
1answer
25 views

Way to Preserve Links when Moving Excel files from File Share to SharePoint?

Is there a way to preserve the links that connect Excel files that are stored on a file share but are moving to SharePoint?
1
vote
2answers
95 views

Fetch lookup column data in excel using ODATA Feed from SharePoint List

I am trying to fetch a data from SharePoint list to excel. Lookup column with multiple choice (person and group field) is not getting populated in the excel. Can anyone help me with this. Below is my ...
0
votes
0answers
19 views

Opening office document from trusted site require authorization twice

My web application has two Site Collections, https://my.server/ and https://my.server/sites/mysite. When I open a excel document in second one /sites/mysite, the excel app is launched and log in ...
0
votes
0answers
25 views

How Can I pass EffectiveUserName to SSAS through Excel Service using FBA(Forms based authentication) in SharePoint 2013

We have an OLAP project which uses Sharepoint 2013 Excel Services to show excel files that contains external data from SQL Server Analysis Services (SSAS) cube. Our Authentication method to login ...
1
vote
1answer
22 views

Excel 2016 can't find SharePoint users in metadata field

I'm developing on SharePoint, but this rather seems to be Office question, so I ask this question in this forum. In Office 2013 there was nice metadata bar, where you could fill different values, now ...
1
vote
1answer
19 views

Sharepoint re-ordering list

I've got a SharePoint Calendar that i've linked to an Excel document and it's currently pulling the data through and dumping it in a table and also a chart on another sheet (But that's irrelevant!) ...
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 ...
1
vote
1answer
24 views

Excel Reporting linked to SharePoint

I'm currently having some issues linking Excel to my online calendar (list) whenever I choose the web as a data source and I enter the URL of the calendar I get the option to only import the entire ...
0
votes
0answers
24 views

Locked Task Solution. Did I break it?

enter code hereI'm a site collection admin. My organization uses Sharepoint-online. We've been plagued by the "This task is currently locked by a running workflow..." messages. It's really crippling, ...
0
votes
0answers
26 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 ...
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
12 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 ...
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
10 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
36 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
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
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
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 ...
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 ...
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
120 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 ...
1
vote
2answers
82 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
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 ...
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
53 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 ...