Questions tagged [excel]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
9 views

How to host a htm page with SharePoint when the files are generated from excel. (Cant change them into aspx..)?

Is there a way to host static html using Office 365 sharepoint? Hello dear community, i have a similar problem.... (Please only real comments... i dont known what to do for weeks. Okay... i want to ...
0
votes
2answers
15 views

How can I update values in multiple excel spreadsheets in a SharePoint 2016 document library?

We have a document library containing 44 excel spreadsheets. Within each spreadsheet there is a "Employee Name" column. Is it possible to update a value (ex. Change "Employee Name"...
0
votes
1answer
14 views

M365 SharePoint Excel Macros

Hi I saw a couple of posts about not running macros in M365 but wondered if anyone could suggest a solution to our specific problem: We have multiple users who need to co-author a workbook in a M365 ...
0
votes
1answer
38 views

Update excel cell from sharepoint column

I know it is possible to define on an excel file some custom properties. And this properties can take the value from a determined excel cell. With this properties created, in a document library you ...
0
votes
1answer
15 views

Enter Value as hh:ss:mm and show it correctly

I´m having a Excel Sheet in which I have multiple rows of raw data in the hh:mm:ss format, now I would like to get these into a SP list. The problem is if I would insert it as a number, what I need ...
0
votes
0answers
18 views

while reading excel from map folder error: failed due to the following error: 80080005 Server execution failed While Opening Excel App From C# Code

While trying to read excel file in C# console application, i am getting following error: "Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed ...
0
votes
1answer
18 views

Changing the mode of excel online to edit in Sharepoint using Power automate

As shown in the below pic I need to change the mode of excel online from view to edit in SharePoint using Power automate. Can we use send an HTTP request option to SharePoint in power automate flow?...
0
votes
0answers
20 views

Excel is reference by the Sharepoint Site name instead of Site URL

Recently migrated files into SharePoint Online via ShareGate tool. There is an excel, which has many formula referencing to different excels. All hosted in same site (but different libraries) in ...
1
vote
0answers
12 views

Execute several ODC (Power Query) and store output file

This may be an X/Y problem. Everyday reports are uploaded on an external SharePoint I have access to. Everyday, I have to manually download the reports, work on them and save as new updated individual ...
2
votes
0answers
23 views

Add row to an Excel table using Flow skip columns values

I'm trying to export a SharePoint list to table in a specific worksheet in Excel (both created in the same Flow), when I try to add a row to the table it doesn't add all the values to the row as you ...
0
votes
2answers
29 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
24 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
104 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
34 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
16 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
33 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
31 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
39 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
16 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
25 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
707 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
69 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
27 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
37 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
40 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
2answers
861 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
13 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
17 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
229 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
25 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
37 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
22 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
57 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
168 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
174 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
27 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
107 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
18 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
1k 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 ...
2
votes
1answer
2k 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
47 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
63 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
27 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
197 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
18 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
50 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
12 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
574 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
42 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
50 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 ...

1
2 3 4 5
17