Skip to main content
Share Your Experience: Take the 2024 Developer Survey

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
14 views

SharePoint Export to Excel removes spaces

I have a Glossary I created as a List in SharePoint in Microsoft 365. There are nearly 1000 entries, and I used SharePoint's "classic experience" to add links between terms. It looks and ...
Lissa B's user avatar
0 votes
0 answers
5 views

How do I save Excel Macro files created from "New" Button in Document Set into SharePoint

I have a libary in SharePoint with Document Sets. Inside of the document sets I allow for a custom content type based of "document". In the template for this custom content type I have a ...
Theo's user avatar
  • 1
0 votes
0 answers
10 views

SharePoint Lists and Excel

I have a SharePoint List of Training Competencies that I am importing into Excel. My intention is for the List to act as the master for all the competencies and an Excel sheet for each trainee. When I ...
MrArcys's user avatar
0 votes
0 answers
8 views

Linking spreadsheets

I am trying to put a formula on an excel sheet in sharepoint which counts all the 'Y''s in a column of a spreadsheet on the same site but one subfolder down =COUNTIF('https://rcofn.sharepoint.com/...
Peter Lyon's user avatar
0 votes
0 answers
16 views

Can SharePoint Hosted Excel Files Use ODBC Connections Without Requiring User Installation?

I'm looking to share an Excel file on SharePoint that connects to a Cloudera Impala database via ODBC. Locally, after installing the Impala Cloudera ODBC driver and providing the database credentials, ...
Tejas Naresh Suvarna's user avatar
0 votes
0 answers
19 views

Disable Real Time Change In View Mode

I have a webserver that serves one webpage which has an embedded Excel document in an iframe. When I view this webpage with a user who has viewing permissions for the embedded Excel link, the webpage ...
Mars's user avatar
  • 101
0 votes
0 answers
17 views

Filepath issue with Sharepoint in VBA

Hope everyone could help me with this. My workplace has moved everything to Sharepoint and one of the file that was created by our former Business Analyst stopped working. The part where it stops ...
Begiiner's user avatar
0 votes
0 answers
16 views

Updating Word Field Links From Excel on Sharepoint

We are moving over to Sharepoint and use field links in our Word docs to update information passed in from a Spreadsheet. If we want the links to work for multiple people they seem to have to be set ...
Keary Wass's user avatar
0 votes
2 answers
56 views

How can I download an Excel 365 document that is stored on SharePoint and over 100 MB, without having to install the Excel desktop program?

Someone shared with me a link to an Excel 365 document that is stored on SharePoint and over 100 MB. When I click on that link, I get that message: Sorry, we can't open your workbook in Excel Online ...
Franck Dernoncourt's user avatar
0 votes
0 answers
20 views

Extracting information

I have list of SharePoint site address in an excel workbook. Need to extract all files (documents, excel spreadsheets, PDF documents) that contain list of specific keywords. The list of keywords will ...
Francis's user avatar
1 vote
2 answers
211 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
20 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
  • 187
0 votes
0 answers
38 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
  • 39
0 votes
1 answer
5k 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
20 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
20 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
18 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
50 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,214
0 votes
0 answers
92 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
54 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
17 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
152 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
1 answer
1k 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
1 answer
678 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
676 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
930 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
164 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
1k 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
50 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
77 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
315 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
165 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
79 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
662 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
1k 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
598 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
69 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
206 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
61 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
31 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
396 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
16k 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
433 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
71 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
160 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

1
2 3 4 5
18