Questions tagged [excel]
Microsoft Excel is a commercial spreadsheet application, which can be integrated with SharePoint.
852
questions
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 ...
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 ...
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 ...
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. ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 >...
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 ...
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 ...
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 ...
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,...
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 ...
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 ...
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 ...
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 ...
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, ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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&&...
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) ...
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?
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 ...
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 ...
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 ...
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"...
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 ...
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 ...
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 ...