Questions tagged [excel]
Microsoft Excel is a commercial spreadsheet application, which can be integrated with SharePoint.
816
questions
0
votes
2answers
25 views
I need to limit rights to save changes in excel through SharePoint
My organization newly implemented SharePoint in our workflow. My problem is excel in SharePoint.
We use a premade excel spreadsheet for calculations for material costs. There is a set of formulas that ...
0
votes
1answer
23 views
How can I share an excel document with a large group users as read-only?
I have our schedule in an excel document that is shared to all the employees via sharepoint. I would like to set it up so that me and a couple other managers have write access to the excel sheet, and ...
0
votes
2answers
32 views
MS Flow 'The requested resource doesn't exist' with Excel file
This is happening constantly the last few days.
The flow pulls the attachment from an email when arrives to a folder. The attachments is a .xlsx.
Then the flow creates a table in the same sheet, then ...
0
votes
0answers
15 views
Excel file corrupted after uploading to SharePoint with VB.NET
Excel file corrupted after uploading (.xlsx file) to SharePoint with VB.NET, I got that error message while opening excel file after uploaded to SharePoint "Excel cannot open the file 'Input.xlsx'...
0
votes
1answer
5 views
Using ADO in VBA to query a nested List table
My List contains a "Person or Group" field, and I have figured out that this is a nested table, with fields of its own. But I am having no luck (de)referencing it. My field is named ...
0
votes
1answer
25 views
Files uploaded in SharePoint Online differ from original
currently using Office365-REST-Python-Client to upload files into SharePoint Online instances, mainly Excel files (xlsx and xlsm). They are uploaded and downloaded just fine, but now I am noticing ...
0
votes
1answer
22 views
SharePoint file updates reminder/push notification questions
I have an Excel sheet (worklog) in my SharePoint folder, I wonder if it is possible to have a feature that:
Send a push notification/or reminder to remind the people having access to the Excel sheet ...
0
votes
1answer
20 views
Can we preserve the colour code when exporting a list into excel sheet
I have a custom list where I applied a color coding for some fields as follow inside modern UI:
But if I export the list as excel, the color code for the fields will be lost. As follow:
So is there ...
0
votes
0answers
13 views
Is it possible to “share” a SharePoint folder using VBA
We have a booking spreadsheet with various double and right click macros to perform automated tasks.
For one option I am creating a folder in a SharePoint site and copying some documents to it.
...
2
votes
0answers
22 views
2021: Recommended way to capture user input & workflow (form? powerapp? word/excel doc?) [closed]
SharePoint Cloud... what is the current/modern recommended method to replace an old school paper form that a reviewer adds/edits content and then an approver does a final approve?
So:
Capture user ...
2
votes
1answer
174 views
Power Automate flow check if date is not empty and null
I have excel sheet. Using Power Automate flow I am reading the excel data.
Using create item action adding the record in SharePoint list. It will not work if the date is empty or null
Column A | ...
0
votes
1answer
24 views
Migrating on-prem Excel to Sharepoint and update Formula links
We have 1000s of files to migrate from on-prem to Sharepoint and many are Excel with formula links.
Is there an easy way to update the formula links after uploading?
powershell?
Has anyone used some ...
1
vote
1answer
25 views
MS Flow stops working when I update the file in SharePoint
I have a MS Flow that updates a list in SharePoint from an Excel file that I manually upload.
Whenever I upload a new file, the MS Flow stops working, see, inside the Excel file I have a table, that I ...
1
vote
1answer
29 views
Is it possible to import data from excel into a SharePoint list, and populate a multiple choice column with the correct data?
So I have a SharePoint List that contains an ID, and a multiple choice column. Now I have an excel sheet that I want to import into the SharePoint list. However, is it possible to populate the ...
0
votes
1answer
37 views
Trying to import an Excel table into an existing SharePoint List, but having difficulties
So I have a SharePoint List that contains a column that holds a special ID. Let's call it orderNumber. Then I have 2 other columns (lets call one Car and the other Color).
Now, both these columns are ...
0
votes
1answer
296 views
Using a Flow to Import Excel Data into an existing SharePoint list
So I have an existing SharePoint list which contains a column that holds a special ID. I have an excel sheet that has a column whose data is dependent on that ID. ex. If the Id is 1, then the ...
0
votes
0answers
12 views
Use metadata for search in columns in library
I am trying to use metadata from an Excel file to use for filtering in our sharepoint libraby. The excel file already contains dropdown menus to pick certain values from, which are then used to create ...
0
votes
1answer
15 views
Import Excel template in an existing customzed list
I would like to import an excel template in a list (tracking to do) that has customized column. Currently, it is empty and I do not want to create tasks line by line in Sharepoint. Do you know a way ...
0
votes
1answer
104 views
Excel cell value needs to be updated in a SharePoint List using Power Automate
I have a document library in which there are different folders which contains excel files. Excel file has name SA_0012ABCD_201901_Report. So here the 0012 is the folder name. So we Match the excel ...
0
votes
0answers
14 views
How to update workbook's named cell from rest API
I want to read and update a named cell from an excel workbook.
If I reach the cell using graph api endpoint, it works:
GET https://graph.microsoft.com/v1.0/sites/{siteid}/drives/{driveid}/items/{...
0
votes
0answers
36 views
SharePoint can't create Excel report in IE
Good day,
I have the script to create Excel report. It works fine for me in IE. But another users can't unload Excel report in IE. If I click F12, I see this error "it is impossible to create an ...
0
votes
0answers
21 views
SharePoint how to export chart to Excel
Good day,
I have the script to show ViewsLastMonths2 and ViewsLastMonths2Unique on SP 2016 page. I show ViewsLastMonths2 on diagram by Chart.js https://www.chartjs.org/
I export ViewsLastMonths2 data ...
0
votes
1answer
55 views
SharePoint 2016 - Require Check Out to Edit
I've set my libraries to require a check out to be able to edit a file. However when I check out a file, it opened in read only and I am unable to save the file. I have no column requirements and ...
0
votes
1answer
81 views
Unable to create SharePoint List from Excel data due to JSON parse error
I was trying to create a SharePoint List from Excel data, I have around 600 rows and 250 columns. I get the error
Then I tried to feed the data less then 250 columns, strangely it works. I tried to ...
0
votes
1answer
89 views
Extract Excel file names into Sharepoint List
I have SharePoint online 2013 and workflow 2010.
I have a list of excel files that I'd like to extract the names into SharePoint List.
Is it possible?
0
votes
0answers
25 views
Excel to Access to SharePoint [Newbie]
Request: Build an MS Access 2013 file (.accdb) that will update a SharePoint 2016 list whenever a user makes edits to an MS Excel 2013 file (.xlsx)
Bottom Line Upfront: I work with a small group of ...
0
votes
1answer
53 views
Update SharePoint from excel
Okay, so I know this question has been asked before. I have read and researched the answers. I have small amount data that needs updating. This is not adding or subtracting records, but updating ...
0
votes
0answers
16 views
Adding a message count for each Team Member of a specific channel
I'm looking for a way to use Power Automate in order to create individual message counters for team members in a spamming channel. I also want to be able to review these counters, by exporting their ...
1
vote
1answer
564 views
Get Graph Drive Id from SharePoint library name
I'm trying to use some graph endpoints in a Flow to access a file in a library that isn't the default Documents library. I need to get the graph id for a file. All I'm starting with are the obvious ...
1
vote
1answer
1k views
409 - This won't work because it would move cells in a table on your worksheet.\r\nclientRequestId: 9f1c2167-ef13-4c30-b1ee-ed56519a54db
I am trying to add rows of data to an excel sheet using a logic app. The headers of the table are created in a different step.
Any ideas on how to fix this, I have tried googling the error code but ...
0
votes
1answer
34 views
.cvs export of sharepoint list removes leading zero's
My site includes functionality that exports a list as a .csv file. I can't change the fact that the list is being exported as a .csv.
The problem is that when the list is exported, the leading zeros ...
0
votes
0answers
53 views
Sharepoint (EXCEL) Index Match reference to another Excel Workbook in Sharepoint
I have 2 workbooks and I would like to do a index match between both.
I have a formula that works between sheets.
=IF(B11="Conventional Machines",INDEX(Sheet1!$N$4:$N$369,MATCH(B7&B9&...
0
votes
2answers
25 views
Update Existing Excel Documents with new Content Type
Is it possible to push changes to an Excel content type to all existing documents a document library with updated content type.
2
votes
1answer
132 views
Parallelism for reading an excel file in Power automate
I have a flow (say x) which is called by other flows multiple times. In the flow x, I am reading an Excel file but I have noticed the flow x stocks in a loop that contains reading from this Excel file....
0
votes
1answer
16 views
File gets locked if users open document from SPO library mapped as a network drive
From our SPO tenant, i added couple of document libraries as network drive.
First time when I open the document, it opens fine and I'm able to make changes and save it successfully.
Next time, when i ...
0
votes
0answers
27 views
Access location and metadata of SharePoint list in Excel
i am a rookie in this community. I am not sure if this question is a SharePoint (SP) or Excel question but I'll give it a shot here.
The Excel file is stored in the SP and is connected to a list on ...
0
votes
0answers
11 views
How te enable changes
I have written an excel application that reads and write to 3 different workbooks.
Although these workbooks are set to read only, there was no problem. Because when i opened these i got a message box ...
0
votes
1answer
402 views
Read excel file in spfx pnp js
I want to read an excel file which is stored in SharePoint library in PNP JS. How can I achieve this ?
0
votes
1answer
39 views
Unable to refresh data from Excel documents
I have a library in SharePoint Online. When on the library I use the Export to Excel button within the tab.
This downloads the query file which I open, after this I click enable on the security notice ...
0
votes
0answers
27 views
Reading excel file from Sharepoint Online issue
I have an existing code reading excel file from the shared drive and importing data into sql (windows app - visual basic). Now that excel files were moved to Sharepoint Online location - existing code ...
0
votes
1answer
79 views
Header won't appear when I open the Excel file on SharePoint, because on the VIEW menu only the NORMAL view exists. How can I add Page Layout View
I have created an Excel file with Header and Footer and I can view the Header and Footer using the Page Layout view when opening the file in my computer.
I upload the same file on SharePoint and open ...
0
votes
1answer
332 views
Append Excel Data to SharePoint List Using PowerApps
I have few users who shares some data weekly using a excel file. Each week I spend time to consolidate each excel file which takes lot of time. I am thinking that can I use PowerApps to provide an ...
0
votes
0answers
136 views
Powershell script to split csv file
I have below PowerShell script to split csv file. This script works fine in my local machine but it is very slow in client's jump box. The size of my original file is around 300MB and splitting rate ...
0
votes
1answer
33 views
Excel File “opens up” multiple times by the same user in SharePoint 2019 using Chrome/Edge, but not when using IE
When opening an Excel in SharePoint using Chrome/Edge, it thinks that the user (in this case Stefan) has opened the file multiple times. It happens, when the user opens it, closes it, and reopens it ...
0
votes
2answers
27 views
How to upload one sheet within an Excel workbook to SharePoint List?
I have multiple Excel workbooks. All of these workbooks have one tab with the same name and format (called "Summary_Table").
My question is: Is it possible to pull and upload this "...
0
votes
1answer
60 views
Working with complex formula in SharePoint
Just wanted to get your inputs on what would be the best way to work with complex formula in SharePoint, while allowing users to easily make edits in the formula (if needed). My understanding is that ...
0
votes
0answers
76 views
VBA unable to fetch the content type properties from Sharepoint
I have my SharePoint connected to my onedrive and use the following piece of code to save the file in the onedrive folders (Which in turn syncs to my Sharepoint) and update the content type properties....
0
votes
1answer
168 views
modifying a Sharepoint Online Excel file in C#
This is the follow up on this question
I can't figure out how to write a data table (called datatble1) in C# to a Sharepoint Online Excel file called ExcelFile.xlsx.
datatable1= dt1;
using (var ...
0
votes
1answer
22 views
Import Excel to SharePoint List Tutorial Error
I am attempting to import/copy excel data into a SharePoint list.
I am following this tutorial to a tee: https://www.udayagirisreekanthreddy.com/2017/12/reading-excel-file-using-html-5-and.html?...
0
votes
0answers
30 views
Sharepoint Excel External SQL
I am trying to have an Excel file in Sharepoint that will get data from a cloud based SQL server.
I have researched this a bit and have not been able to find much. Everything I find leans to Power BI ...
