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

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

0
votes
0answers
10 views

The Excel client app “forgets” that an open file is checked out to the current user

Scenario An employee navigates to a document library that requires documents to be checked on our SharePoint 2016 on-premises environment. They then edit an Excel file (e.g. by right-clicking on the ...
0
votes
1answer
17 views

Append to existing text - Exporting to Excel

I have been looking online and can't really seem to find any clear information relating to this so thought I would pick all of your brains. I have a custom list with a multiple lines of text column ...
0
votes
2answers
22 views

Restrict downloading of documents from sharepoint with edit permissions

Can I restrict users from downloading documents if they have edit permissions in sharepoint? I have an excel file that my staff all need to collaborate on, but I do not want anyone to be able to ...
1
vote
1answer
28 views

Linked images (cells copied from other spreadsheets pasted as linked image) do not show in Excel Web Acess Webpart on SharePoint page

I uploaded Excel file with multiple sheets and a Summary sheet(just another spreadsheet in same file) containing charts and cells pasted as "linked images" from other sheets in a document library in ...
0
votes
1answer
22 views

How to import data into Excel from MS Access?

If I put an MS Access database on Sharepoint or One Drive, how can I import/link the database table into Excel? My Excel will also eventually be on Sharepoint. Current as a PoC, I put the database on ...
1
vote
1answer
31 views

unable to refresh data in excel from sharepoint

I am using SharePoint 2010 and excel from office 2016. When i give export to excel from the SharePoint site, it works fine and loads the data in excel first time. But when i try refresh the data, it ...
1
vote
1answer
33 views

can we install a SharePoint 2013 KB in SharePoint 2016 environment

We are in process of migrating our SharePoint 2010 environment to 2016 . While we are having SiteMinder agent as authentication when we try to access the word/excel/ppt documents in Chrome browser it ...
1
vote
2answers
62 views

'Open In Excel' option is grayed out for .xlsm files in Sharepoint 2013

We know that excel files with macros and password protections are not supported to view in Browser using Office Web App / Excel Web App. In this SharePoint shows small dialogue where it has 'Open In ...
0
votes
1answer
15 views

hyperlink not working in excel web access sharepoint 2010

I posted an excel web access on my SharePoint, the file contain a list of hyperlinks to a Library of documents. the file uploaded fine, but all the hyperlinks are unaccesible. Is there a way to keep ...
0
votes
0answers
17 views

Excel documents failed to open in client

One user tried opening MS Office excel document which has macros in it, due to web app restriction he was able only to open document in client. While opening, excel notified him as standard ribbon ...
0
votes
1answer
17 views

Can't share exported excel from SPO

So i've been wasting a lot of time trying to solve this with no luck. Someone in my team created a excel file by using "Export to excel". On her PC it works perfectly, however...nobody else can ...
0
votes
0answers
13 views

Excel broken links - migrating from File storage to SharePoint 2016

Good day Guys Do anyone have experience in using 3rd party tools to manage or fix links between excel sheets when moving them over from normal file storage to SharePoint 2016 on-premise. it is my ...
0
votes
1answer
21 views

How to define how a file from Sharepoint is opened

On our company Sharepoint with have besides others a lot of Excel (xlsx) files. And we have Office 365 installed on our laptops, don't know whether this is important for this question. When I click ...
1
vote
1answer
29 views

How can I make it so only certain users' changes are saved and everyone else's are discarded?

I have an excel database that we use to store product information. The admin of the sheet is the only person who should be able to edit the information on the sheet, which is easy to do through ...
1
vote
1answer
53 views

Cannot connect to SharePoint Online list from Excel

I'm trying to connect to a SharePoint Online list from Excel, and I keep getting the error "We couldn't authenticate with the credential provided". I logged on to this list from Excel in the past ...
0
votes
1answer
55 views

Excel to SharePoint List: How to have a Choice column with multiple values?

I want to do the inverse of this post. What do I need to type in my excel field to automatically create a Choice column in SharePoint with multi values when importing the Excel file via the Import ...
1
vote
1answer
41 views

Exporting item version check in comments

I have followed this answer to extract the list of versions in my document library to excel: However, while the table lists all the versions it only displays (and repeats) the most recent check-in a ...
0
votes
1answer
16 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
97 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
17 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
27 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
37 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
22 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
32 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
267 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
25 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
34 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
26 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
34 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
53 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
35 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
16 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
53 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
42 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
9 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
15 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
11 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
52 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
19 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
298 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
20 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
270 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
50 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
32 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
14 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 ...