Questions tagged [excel]

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

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

Comments in read-only Word/Excel files

Do you have any ideas on how to allow users to comment/discuss on contents in Word/Excel files when the users only has read permissions to the documents? Ideally we would like to use the built-in ...
Tommy Jakobsen's user avatar
1 vote
1 answer
13 views

Excel App & read-only SPO folder

We have a strange behaviour of excel with files on SharePoint. The situation is as following: User has read-only rights on SharePoint Folder (also read-only) contains Excel file Excel file is set to ...
Der_Fab's user avatar
  • 177
0 votes
0 answers
14 views

Office Scripts not shown in Power Automate

I created a flow for adding value in excel. for which I want to use office script but office script is not visible in script section . How can I add value in certain column of excel using the above ...
Renuka's user avatar
  • 37
0 votes
1 answer
74 views

Setting up an email reminder based on dates in excel sheet

I've been asked to find a way to have an excel spreadsheet (that will be updated often) send an email to the email address from a column, as well as on a specific date according from another column. ...
Guest G's user avatar
0 votes
1 answer
19 views

converting a semi-structured excel database into a sharepoint database

Our company has an excel customer-record cheat sheet. we're trying to integrate that cheat sheet into SharePoint. However, the sheets in the excel cheat sheet are not relational structured data. Some ...
start's user avatar
  • 1
0 votes
0 answers
19 views

How to read excel file in SharePoint and write data in to new file on same sharepoint

I'm now creating a microsoft form which will accept excel file upload. All files will be uploaded to SharePoint site folder, that all successful. and now I want to read all rows from each file (there ...
Anue's user avatar
  • 1
0 votes
0 answers
12 views

Entering data into an excel sheet with PnPjs

I want to create a webpart for a sharepoint site, that allows users to enter an identifier about the sheet then using PnPjs i want to allow users to enter that data into the sheet. I would have ...
Carter Tomlenovich's user avatar
0 votes
0 answers
32 views

Powershell to read excel and update metadata in different document library based on a cell value by matching the unique file name

I have multiple libraries storing only document with unique name, site wise. I need to update metadata for these uploaded documents based by reading an excel sheet. The twist is that it updates ...
cjs's user avatar
  • 1,204
0 votes
0 answers
40 views

Power Automate Excel to Sharepoint: update item if any column in Excel table is different (not just 1 unique ID)

Question summary: How can I update a list item if ANY value in the Excel row has changed? I'm somewhat familiar with Power Automate now and can figure out flows. I want to update a Sharepoint list ...
rustcat's user avatar
0 votes
1 answer
47 views

Extract Excel Metadata

Is there a method or feature available in Excel that allows the extraction of file metadata from the content of an Excel file, similar to the functionality provided by Word's "Insert > Quick ...
Mori's user avatar
  • 11
0 votes
0 answers
14 views

How can I reach the path link in the details sidebar when the activity constantly refreshes?

Dont really know how to expand on the title, but im querying excel files in a sharepoint folder. Someone has changed the name of the files which has broken the links, so I am restablishing them. When ...
Leigh's user avatar
  • 1
0 votes
1 answer
111 views

Power Automate - Slow performance - date formatting from excel , copying to list

I have this workflow where I have two apply to each and many compose fields. Is there a way to optimize this for faster execution? I am getting an error about slow running. The excel table has only ...
Jonnyboi's user avatar
0 votes
0 answers
12 views

Page performance displaying Excel files

I have a page that I have added 2 Excel files to be displayed on - the files are located in the site documents folder and do not have much information in them. The performance is very poor though - is ...
Kerry McIlwain's user avatar
0 votes
1 answer
954 views

Power automate flow - Cannot use 'list rows in present table' in apply to each

My "Apply to Each" - "value" is coming from Get Tables, shouldnt it be coming from "List rows present in a table" but this option is not available in dropdown. If I do ...
Jonnyboi's user avatar
0 votes
0 answers
61 views

I have an Excel file with pivot tables accessing external data (a separate Excel file). Where do I put this external data file?

I have an Excel file containing both VBA macros, and pivot tables which access data from an external source (another Excel file). I've been asked to share this dashboard via SharePoint. As it ...
Matt Akers's user avatar
0 votes
0 answers
14 views

Cannot add excel file in web access excel web part in SharePoint Server 2013 on premises

The problem I'm facing is that when I'm trying to add an excel file into a web part of a SharePoint Server 2013 web page. I'm receiving the following error: The workbook cannot be opened" Any ...
Panos's user avatar
  • 1
0 votes
0 answers
18 views

Can SP remind user to check in a document when finished?

My SP 2016 site has an Excel spreadsheet that receives monthly updates from many users. Often a user will save and exit the document without checking it back in, leaving others unable to add their own ...
carston1998's user avatar
0 votes
0 answers
80 views

EXPORT LIST IN SHAREPOINT TO CSV

"I have a list in SharePoint with a column named 'DateTime'. When I export the list to Excel, the 'DateTime' column is displayed correctly in the format 'dd/mm/yyyy hh:mm'. However, when I export ...
cristo arael's user avatar
0 votes
0 answers
38 views

Encrypted Excel File "xlsx" is 'corrupted' after downloding but Encrypted Excel File "xls" or "csv" are working fine

We have a strange error on our Sharepoint 2016. When we attempt to download an excel file version "xlsx" through our workspaces, it will show that the file is corrupted after being ...
dexter 's user avatar
0 votes
0 answers
80 views

SharePoint Online - Preventing changes to excel files saved as read-only from the "Protect Workbook" section in excel

The workflow I am trying to accomplish is as follows, using SharePoint Online + Office 365: User creates excel file locally, saves it to SharePoint site as read-only using the protect workbook ...
Jack's user avatar
  • 1
0 votes
1 answer
423 views

Modifying already existing excel file in the sharepoint site

What is the recommended method for modifying an existing Excel file stored in a SharePoint site without downloading it locally? Are there any specific APIs, such as the Microsoft Graph API or the ...
Alireza Khaleghi's user avatar
0 votes
0 answers
50 views

Can we map the excel dropdown as combobox or dropdown inside Power Apps form

We have this excel sheet that contains 2 tables (Items and Status) >> the Items table has a drop-down to the Status table as follow:- now when i mapped the 2 tables inside Power Apps canvas >...
John John's user avatar
0 votes
0 answers
492 views

Slow Data Refresh Sharepoint + excel

my queries are taking a long time to update and with the sharepoint being used as a "database", I know it's not right, but it's the current scenario in the company a spreadsheet with 25 ...
Rhels Ziliani's user avatar
0 votes
1 answer
2k views

Open URL hyperlink from excel application or excel online to a specific worksheet

I'm looking to create hyperlinks from Excel Online/Application to Excel sharepoint files. After looking throught the forum, I found solutions to create working links : From Online App From the ...
Macronaute's user avatar
0 votes
1 answer
837 views

SharePoint Date Format Customization

One of our client requirement is to show "DD-MMM-YYYY HH:MM:SS" date format in all the date columns in SharePoint List and custom dashboard (built using SPFx). Using custom code logic we ...
Zakir HC's user avatar
  • 3,650
0 votes
2 answers
130 views

Import an excel column to a empty column in an existing list

Are there any efficient ways to import an Excel column to a empty column in an existing list in a SharePoint online site? Currently I am using Ctrl + C > Ctrl + V but, since the values are too many,...
Ed_Gravy's user avatar
  • 119
0 votes
1 answer
800 views

The format of the clipboard data is not recognized

While copying (Ctrl + c -> Ctrl + v) data from a filtered Excel sheet to a SharePoint online list, I keep getting this error: The format of the clipboard data is not recognized I checked my data ...
Ed_Gravy's user avatar
  • 119
0 votes
2 answers
43 views

How to access SharePoint Online SPFx application in MS Excel?

I want to develop an SPFx application that can be accessed using MS Excel. When a user opens Excel, our SPFx solution is already ambaded there. Please share any ideas using which I can achieve the ...
Parth Shah's user avatar
0 votes
1 answer
59 views

Digital Signature error in Excel / SharePoint

I have a team that is co-authoring an Excel workbook. Occasionally, when the file is opened, users get a message the file can't be saved due to change(s): Digital signature(s). (A photo is below.) We ...
VASoftball5's user avatar
0 votes
0 answers
222 views

Power Automate/Sharepoint file - multiple updates, but file locks after first

I'm working on a Power Automate flow for my work. I'm pretty new to it, but I was making headway until I hit this issue. I have a button in the sharepoint library. It has three key processes Copy the ...
asw122's user avatar
  • 1
1 vote
0 answers
2k views

Retrieving local path of a file hosted on SharePoint

I am actually at the end of my rope here, I'd really appreciate any insight however small. The scenario is as follows. My company hosts the majority of its data on SharePoint. For config management, ...
bankpainmedia's user avatar
0 votes
1 answer
144 views

What is the most efficient approach to pulling data (using Vue) from a SP list to then export it to Excel?

I've run across many descriptions on how to effectively/efficiently set up a click event that pulls data from a single SharePoint list and then exports the data to Excel in a Vue.js environment. So ...
readytodrum's user avatar
0 votes
1 answer
62 views

updates to very large SP lists

I have an Excel sheet with 200K rows and I want to replace it with a SharePoint 2016 list, since Excel files in SP don't allow for simultaneous editing by multiple users. Ideally I would create a ...
carston1998's user avatar
0 votes
0 answers
514 views

Linking Excel tables to Word when files are hosted on Sharepoint

I am attempting to create a linked table in Word that is intended to update automatically from the source Excel document. The intent behind the linked table is to be able to quickly update all of the ...
WhatsAPowerQuery's user avatar
0 votes
2 answers
906 views

Why can't "Type" be a column name in SharePoint list?

I am new to SharePoint list and PowerApps. When I create lists, I can not add a column name called "Type". It said the column name already exists but the column was not in my list. When I ...
Pete's user avatar
  • 103
0 votes
1 answer
482 views

Sharepoint 2016 .iqy file keep asking for login

One of my client is using sharepoint 2016 and he wants to export the sharepoint 2016 list to excel, so From couple of days, i'm facing issue of exporting sharepoint 2016 list to excel using there ...
Lokesh Thakur's user avatar
0 votes
0 answers
63 views

Migrating a list from Excel Into SharePoint Using Power Automate

I was recently experimenting with Microsoft PowerAutomate and I have encountered a following issue. I have a large Excel list that contains up to 330 rows of data. I would like to migrate that list ...
Mateusz Woś's user avatar
2 votes
0 answers
179 views

Updating a Sharepoint list with input from an Excel file using Power Automate

I previously did this using MS Access. I have a worksheet in an Excel file, let's call it the input, that is the source for the update for a Sharepoint list. For easier labelling, I'll call the item ...
Pete's user avatar
  • 21
0 votes
0 answers
1k views

Open excel in a SharePoint with VBA in edit mode

I want to edit an Excel stored on a SharePoint but the file can't be modified. I use this code to open the distant file and edit: Private Sub test() Dim destFolder, fs, f Dim ptrFile Set ...
Foxrider83's user avatar
0 votes
2 answers
1k views

Missing Create List from excel option

We have SharePoint Server 2019 version deployed, we moved from SharePoint Online to On-Premises version to satisfy Government regulations. Here, I am trying to create a list following the guide from ...
Noorul's user avatar
  • 31
0 votes
1 answer
57 views

Converting Excel formula to SharePoint Calculated column formula

I'm pretty new to SharePoint calculated formulas and am struggling to convert an Excel formula I have to a SharePoint calculated column formula. The Excel formula is =FLOOR(280-(J5-TODAY()),7)/7&&...
laser132217's user avatar
0 votes
1 answer
2k views

Convert .xls file to .xlsx format in SharePoint using PowerShell

I have .xls files (Eg: Book.xls) available in my SharePoint Online folder (https://.sharepoint.com/sites/test/Shared%20Documents/Book.xls"). I want to convert them to .xlsx format (Eg: Book.xlsx) ...
Akhil's user avatar
  • 1
0 votes
1 answer
30 views

Excel Web Part Displays an empty box

When adding an excel web part to a SharePoint page, I always get an empty box below any chart or table that I’ve added. I can’t seem to figure out how to remove this empty box. Any ideas?
Misty's user avatar
  • 1
0 votes
1 answer
278 views

How Do I Export Sharepoint List To Excel Online?

I want to copy the list of directories in my Documents in Sharepoint but selecting the list on the page and copying and pasting it has been disabled. The Export to Excel button saves a query.iqy file ...
opticyclic's user avatar
0 votes
5 answers
14k views

Column "does not exist. It may have been deleted by another user?

I cannot create a list on either the Page or SubSite for several Excel files. I am getting the same warning message telling me the same thing shown below (Column " does not exist. It may have ...
lobosmtv's user avatar
0 votes
2 answers
377 views

Live update sharepoint, when Excel Desktop has been modified

So I have created a table in Excel Desktop. This Excel document should be available for everyone at my department, hence I have uploaded this Excel document to a shared SharePoint. However, if I make ...
rama96x's user avatar
0 votes
2 answers
53 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"...
C1TonyB's user avatar
  • 435
0 votes
1 answer
136 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 ...
David G's user avatar
  • 79
0 votes
1 answer
782 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 ...
Raul Ortega's user avatar
0 votes
1 answer
336 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 ...
Paul's user avatar
  • 1

1
2 3 4 5
18