Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

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

0
votes
1answer
15 views

Exporting item version check in comments

I have followed this answer to extract the list of versions in my document library to excel: https://sharepoint.stackexchange.com/a/190023/32474 However, while the table lists all the versions it ...
0
votes
1answer
12 views

Send Email When List is Created by uploading Rows from Excel File

I have a query about Sharepoint List in sending emails. Help needed in creating the below requirements please - Upload excel file contents having multiple rows/columns Example- Name City Country ...
0
votes
0answers
7 views

Open excel template file from sharepoint through link in VBA

I am trying to create a program in excel with VBA which opens a file template located inside my sharepoint. The program tries to open the file through the sharing link provided from the sharepoint and ...
3
votes
0answers
14 views

ADO.NET Data Services for SharePoint 2016?

As I was asking in a related question, I'm trying to figure out how to get a PowerView report going that is using a SharePoint list as its data source. In researching how that can be done, I found ...
1
vote
1answer
25 views

Requirements for excel data refreshing

What are the requirements to be able to update data that came from Sharepoint (using Export to Excel button) by Excel "Refresh All" button? On some machines I can refresh (when authentication prompt ...
0
votes
1answer
14 views

Can't update data Excel Online from Azure SQL datasource

Here's what I've done: Created new Excel file on my desktop. Added connection to Azure SQL using database authentication. Read in a view. Save this document to Sharepoint for my tenant. It's hosted ...
1
vote
0answers
21 views

Linking web parts of documents that are linked to other documents

I currently have a whiteboard where I have put up documents and charts as a visual representation. I would like to digitalize this board in SharePoint, so that I can make changes in the original ...
0
votes
0answers
27 views

How to import an Excel sheet to a List in SharePoint?

In this video i found the first way so easy and great. but the problem is when an new record inserted in the excel sheet i have to create a new list with different name, so is there any way to update ...
0
votes
1answer
46 views

Connect excel to access to Sharepoint

Im trying to sync excel and Sharepoint so I can update an excel table and changes appears in sharepoint. Since I’m using 2016 versions for excel and Sharepoint I noticed it’s not as easy because I ...
0
votes
1answer
16 views

How to calculate value for calculated field in SharePoint using formula?

I have a date field called Start Date. I am using column validation to allow users to select only 4 date values, if they enter other than this they see a validation error. So based on this Start Date ...
0
votes
1answer
19 views

How to handle Excel 2013 data queries for large lists (>5,000 items) in SharePoint online O365?

I would be interested if anyone has a suggestion for handling this. I am working in Office 365 (but with Excel 2013), so I can't change any of the SharePoint throttling behavior for this list. ...
1
vote
0answers
25 views

Opening Excel files from SharePoint Online

When one of my users opens any Excel file from SharePoint Online in the client Excel seems to ask for their O365 credentials. The user enters their credentials (despite being signed in to Excel) but ...
1
vote
0answers
16 views

InfoPath button for Excel export

I want to add a button in InfoPath that will allow me to export the form into Excel. Is this possible? This is a requirement that client needs, and I have no idea how to do it without just saving the ...
0
votes
0answers
18 views

SharePoint List - Export Text Areas (Multiple lines of text) to Excel

On my task list, I have a few text areas that allow the user to explain what the issue is etc. When exporting the data to an excel spreadsheet it won't actually show the entries, it shows the column ...
1
vote
0answers
5 views

In Powerpoint - browse window not displaying all information

In Powerpoint, Excel (native app, not web version) when I attempt to open files following the path:File >> Open >> Browse >> Sharepoint Pinned Folder ... the file names are missing, covered by a white ...
0
votes
1answer
31 views

If there any option inside sharepoint document libraries to allow multiple users to work simultaneously on the same .xls file tabs

We are working on a sharepoint 2013 team site. and inside the document library we have a .xls file which contain 5 tabs. so now oor users are asking if multiple users can work simultaneously on the ...
2
votes
0answers
15 views

Save file in same document set it is opened from

I have a request from a customer I am struggling with. Given is the following scenario: SharePoint Server 2016 Whenever a new document set is created a specific Excel file is added to the document ...
0
votes
1answer
20 views

How do I create an formula in SharePoint Online?

hope you're well; I would like to know how to create a formula for weekly in SharePoint online. For example Tax year is April 2018 but I would like weekly number to be from Tax year.
0
votes
0answers
21 views

Download excel file on company sharepoint on to linux server

Want to setup a process where i can download a file on company sharepoint on to linux server. Tried following wget --http-user= --http-password= "" I am able to connect to the server but for some ...
0
votes
0answers
25 views

Excel Online - Sharing workbook between two companies,

We're currently using Google Sheets to offer a online tracking system for one of our customers. So for example, in columns A B C, we would enter specific details, and our customer would complete ...
1
vote
0answers
7 views

Linking a sharepoint list to Excel Online

I have a list in sharepoint. I've figured out how to extract it to Excel, and create a data connection. My question is, how do I extract it and create a data connection to Excel online/Excel in ...
0
votes
1answer
14 views

Export from Excel to CONTACT type list

I was able to export from an excel table to sharepoint, however it just creates a normal list. I want to import data to my CONTACTS LIST in sharepoint via excel, or maybe there is another way to do ...
1
vote
0answers
10 views

Search results show hidden tabs in excel

I have a problem that concerns the search function, I have it set to search only in a specific library, which works perfectly. However, it works a bit too well. It actually searches among my hidden ...
0
votes
0answers
16 views

Open Password SharePoint file with VBA?

I am trying to open a file we have on our SharePoint that has a password on it and must be checked out to edit. For some reason I keep having to enter the password even though it is supposed to be ...
0
votes
2answers
18 views

Excel in SharePoint - Refresh button directs to “Save As” which doesn't save changes

I use several Excel spreadsheets stored on our company's internal SharePoint site. When I open these in Excel ("Edit in Excel", not the Excel web app), then click the Refresh button at the top, it no ...
0
votes
1answer
123 views

Importing Spreadsheet to SharePoint 2013

when attempting to import a Spreadsheet from Excel to SP13, I get the error "List cannot be imported because SP Foundation-compatible spreadsheet is not installed or compatible with your browser.
0
votes
1answer
10 views

New to SharePoint 2013. Trying to create a user facing informational list

I am new to SP 2013, sorry if this is ridiculous or not feasible. I work with automated calling and text messaging for a large organization. By default, a department is set to auto call, but can ...
0
votes
0answers
12 views

PowerPoint slides on SharePoint are deleted while opening from Excel with VBA

I run a VBA macro from Excel that has to open PowerPoint presentations on SharePoint, read something from a slide and write it to Excel. The Makro ran on a Windows 10 VM for some weeks without any ...
0
votes
0answers
18 views

Ban users from modification when opening excel file

I'm using sharepoint 2013 and I have put a rich html that allows users who have the rights to put whatever they want. They can put for example an excel file. However in IE I have a problem, when users ...
0
votes
0answers
119 views

Saving an Excel file as pdf in sharepoint Online using VBA

My scenario: following a migration i have done for a client,I need to rewrite some of the macros and one specifically is not working. What i need is to be able to save the excel as a PDF in some other ...
1
vote
2answers
45 views

open excel file from spfx onclick

I'm working on a spfx app in reactjs and need to open an excel file. Does anyone know the best way to do this? now i'm using window.open(d.ServerRelativeUrl, '_blank'); but this downloads the file ...
0
votes
2answers
29 views

How to publish only(!) parts of an Excel-Document on a SharePoint 2013 server?

We have an Excel document which contains in 2 columns information about a product (column A) and its delivery time (column B). In column C, there are also internal comments about the reasons for this ...
0
votes
1answer
17 views

Export workbook data from different files to SP 2013 list

I have a main site from which new subsites are created whenever a new project is started. In each of these sites there's an Excel standard document where people fill in data about that specific ...
0
votes
0answers
12 views

Excel Web Part not loading/displaying selected workbook SharePoint 2016

A bit of a tricky one here, tricky for me anyway. I have added an Excel Web Part to my page and I have selected the workbook I wish to load however after selecting it through the web part ...
0
votes
1answer
33 views

Show Export to excel button of list in main view

When I go to route Site Content --> My List , I can see export to Excel button It works correctly as I want, problem starts when I publish my list, I want to see that Export to Excel in main view(...
0
votes
1answer
42 views

Export hidden columns to Excel

I´m working in Sharepoint Online. Now I export an excel with current items of list and it´s ok, but I want to export all items of list. How can I do to include hidden columns into index list then ...
0
votes
0answers
41 views

Export to Excel in Default Edit View

I have normal list in sharepoint online, into it I have items, and I have edit form, I want to know if its possible to do something to export to excel fields of edit form. We can achieve it with JS or ...
0
votes
0answers
19 views

Error “Cannot contact server” when importing excel sheet to sharepoint

My scenario : I am trying to import data from a spreadsheet to a SharePoint list. First try: I have use Internet Explorer to import the spreadsheet using an add-in that SharePoint provide OOTB(Note i ...
0
votes
0answers
24 views

Difference in default open behaviour Excel

Recently I encountered something strange: two Excel documents in the same library that opened differently; one of the two opened in the browser (and had the choice how to edit, in browser or client), ...
0
votes
0answers
39 views

Excel File on SharePoint as a Data Source

I am building an SSIS package that will load an excel file into a SQL Server table from sharepoint. This excel file is loaded into the sharepoint folder on a daily basis automatically through the ...
0
votes
0answers
164 views

Open office document stuck on contacting the server

I cannot open Excel or Word documents. There is a message "contacting the server..." but the file won't open. The Sharepoint version I am using is 2013 on premises. I manage to open Office dcoments ...
0
votes
0answers
8 views

SharePoint workflow from list to create a changelog file

So i'm brand new to sharepoint and i've been assigned a task to see if its possible to create a flow so that when a list is updated/new row is added it saves those changes in an excel file or similar ...
0
votes
1answer
124 views

Is it possible to update cell in excel file located in SharePoint library With Javascript?

I wonder if it's possible to change/Update a cell value in Excel file located in SharePoint online using Javascript?
0
votes
0answers
17 views

Exporting SharePoint Members into Excel required permissions

I followed the instruction provided using the Data from Web options. I received a message saying: "Access to the resource is forbidden." I am the owner of the site. I am creating an auditing tracking ...
0
votes
0answers
31 views

Can GraphAPI read and Write to excel hosted on SharePoint Online Document library?

Can GraphAPI read and Write inside excel files hosted on a SharePoint Online Document library? How about tables inside the Excel? I am trying specifically from a JavaScript Client. Part of why i ask ...
0
votes
0answers
29 views

Automatically save excel document to SharePoint weekly

I'm not sure what information will help to answer this question, but, I would like to automate a process (without admin rights) to save a copy of an excel document to a SharePoint site that I have ...
1
vote
0answers
138 views

Update SharePoint Online list when new row is added to Excel

So, I'm working on this project where my client wants to send forms with simple yes and no questions to their customers, adding each customer to a SharePoint list when the form is submitted. The ...
0
votes
1answer
171 views

How to sync an excel pivot-table with a sharepoint list?

I have a sharepoint list that I would like to connect and sync with a pivot table included in an excel file. The excel fiel is a 2010 version and is stored in the same sharepoint. Is it possible to do ...
0
votes
0answers
25 views

Automatically populate a timeline webpart from an uploaded excel spreadsheet

I'm wanting to see if it's possible to have an uploaded excel spreadsheet where several users will be editing and inputting data on a regular basis, automatically populate a timeline web part. The ...
0
votes
2answers
199 views

Word and Excel co authoring in SharePoint 2016

There is a lot of confusion on this topic so I just want to confirm if following is true: Word = Supports co-authoring via both desktop application and Office Online Server/Office Web App Server ...