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
14 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
21 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
24 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
25 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
41 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
19 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
11 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
18 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
55 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
12 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
14 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
73 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
32 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
22 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
33 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
65 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
31 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
21 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
25 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
33 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
21 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
34 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
29 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 ...
0
votes
0answers
14 views

Excel Web Access - Chart linked to external workbook not pulling data

In short, I have two Excel workbooks (2 separate files) on SharePoint 2016. The first is a bunch of data. The second is analysis of the data, charts, etc. in the form of a dashboard. All of the ...
0
votes
1answer
26 views

Excel file issues in OneDrive

I was working on an excel file from past 1 week. This file was saved only on One drive and not on my disk. Till yesterday everything was fine. But today when I open the file, everything I worked from ...
0
votes
0answers
17 views

REST or ADODB? What provides the best performance of creating an Excel VBA tool?

I’m creating a small Excel VBA tool that performs basic CRUD operations to SharePoint lists. Ha-ha, I know, probably a terrible solution but it’s all we have or allowed to work with at the moment. I’...
0
votes
0answers
112 views

Display SharePoint Online document property in Excel cell

I'm attempting to access and display a SharePoint property I've set for Review Date of an Excel document. The property is visible in a column in the Document Library. This is easy to do in Word by ...
0
votes
2answers
167 views

Getting data from SharePoint Online in Excel 2013 spreadsheet - unable to refresh one or more data connections (when refreshing in browser)

Environment SharePoint Online Excel 2013 with Power Query Add In Desired Behaviour When I click 'Refresh All Connections' in a spreadsheet file in a SharePoint folder: data from 2 x SharePoint ...
0
votes
1answer
36 views

Excel import OData feed URL from SharePoint 2016 get 401 error

I want to establish an OData datafeed in Excel 2013 to connect to a SharePoint 2016 list. In the Excel, data tab -> from other source -> from OData datafeed. Then I input our SP2016 url: https://...
0
votes
0answers
13 views

I need to get the excel file which is contained within the collection based on listdata.svc call

I am having trouble with using an excel document which is part of a Documents Collection in SharePoint. In SSIS I have created an OData connection which points to: https://company.sharepoint.com/sites/...
0
votes
2answers
687 views

How to enable ‘Forms for Excel’ in SharePoint/Office 365

I am an Office 365 global administrator, looking after two SharePoint sites. One has menu items for Forms, but the other does not. The site that works is new, created since we started using Forms. ...
0
votes
0answers
7 views

Complex Drop List Formula

I have a dropdown list named “Frequency” on column F with options as follow:- Weekly Biweekly Monthly 2x per week Now I want to create a calculated column named “Next outreach Date” (Column H) ...
0
votes
0answers
159 views

Wrap Text not working in SharePoint Excel

Text just appears squished instead of wrapping to the next line. Oddly when I download the file locally the wrapping works perfectly, just in SharePoint does it behave this way.
0
votes
0answers
7 views

Saving and Renaming Excel file Does Not remove 256 user Error

I'm hoping someone might be able to help me. I have read the other post here created a few years ago regarding this same issue. Unfortunately, I've tried saving the Excel file locally, renaming, and ...
0
votes
1answer
37 views

Can I embed an excel file in a sharepoint page so it can be used, but not downloaded?

I have an instructor who teaches excel, and wishes to administer an exam, but doesn't want the students to be able to download the file. Is there a quick way to embed the excel document into a ...
0
votes
2answers
348 views

Powershell : Read excel file data in document library and then modify it and upload it back using powershell in SharePoint Online

I am looking for powershell solution which will read xml file in document library and loop throgh all rows and add/modify rows/columns on the excel file and upload it back to sharepoint. Tried ...
0
votes
0answers
38 views

What is the correct API and node SDK to append rows to Excel in Sharepoint Online?

I've been asked if I can change from appending row data from Google Sheets as I currently am, to "an Excel sheet in Sharepoint [online]". Really very simple - "date, time, event" appended to ...
0
votes
1answer
16 views

Update URL's link Inside Office (docx, xlsx) documents

We need to change the root of our SharePoint 2013 Document Management site collection due to a company ownership change from Sharepoint.acb.net to Sharepoint.xyz.net. I configured everything using the ...
0
votes
1answer
54 views

Sharepoint: Mass Create “Link to Documents” from List in Excel

Background: We have a running index of files within an Excel workbook that we use to list and maintain our files and related attributes/categories. This workbook includes a data column with links to ...
0
votes
0answers
8 views

Excel doesn't update file, when file is still open after checkin

we have the following Setting: We're using SharePoint 2013 on Premise and Microsoft Office Professional Plus 2016. Now here is the Problem: I have an Excel file in a Document library. User A opens ...
0
votes
1answer
125 views

Need to create a microsoft flow to trigger email based on the email address mentioned in the excel row

I am working on an excel which contains Name, Amount, quantity, email address and a dropdown - Send Email - Yes/No. I am trying to build a microsoft flow where I want to trigger an email when a user ...
0
votes
0answers
26 views

Upload all folder files to SharePoint document library

I am working on code which will upload all ShareDrive folder files to SharePoint Document library: I need this to be done via VBA I have an excel, at A2, there would be ShareDrive Path and A3 would ...
0
votes
0answers
47 views

How to save Excel w/Macros to SharePoint

Good Day, I've reviewed the following questions Excel Macros in SharePoint and How to handle Excel sheets with macros and am still stumped. So... We have an Excel Spreadsheet that is full of macros ...
0
votes
0answers
98 views

blank page when i open Excel sheet on SharePoint online

when I open an excel sheet on my SharePoint online site (open in browser ), it gives me a blank page it's not even download -I am the owner of the site (Team site) -checked different browsers \ ...
0
votes
0answers
30 views

Export to Excel displays no results

I am new to SharePoint (2007 version) so please excuse any basic errors. I have created a survey in SharePoint that has a mixture of yes/no, multiple choice and free form text answers. Prior to ...
0
votes
0answers
21 views

Excel VBA to fetch Views information from SharePoint Document Library

I need to fetch the List of views and view information in SharePoint Library.How can I achieve it using Excel VBA. I tried to search around, but was not able to find relevant solution. Thanks in ...
1
vote
1answer
362 views

Using Power Automate to Export Outlook .xlsx Attachment to SharePoint List

I'm in the middle of setting up an automated flow using Microsoft Power Automate and I have some questions. I'm seeking to extract an .xlsx file from an Outlook email attachment and have the data from ...

1
2 3 4 5
17