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
12 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
17 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 ...
  • 1
0 votes
1 answer
26 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
13 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
49 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
221 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
0 answers
108 views

Using Power Automate - Create Sharepoint List with column headers and row contents from Excel sheet

As per the header but I'll start with some background. I was tasked with creating an app that would give reduced access (via an app front end) to an excel spreadsheet. I have created an app (and some ...
  • 1
0 votes
0 answers
4 views

How can I archive/present templates, while allowing visitors to search for templates by specific categories on sharepoint site 365

Sharepoint office 365. Templates are categorized on excel. PDF available for each template.
0 votes
1 answer
448 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 ...
  • 3,650
0 votes
2 answers
25 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,...
  • 119
0 votes
1 answer
186 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 ...
  • 119
0 votes
2 answers
22 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
0 answers
16 views

PowerAutomate - Recognizing emply excel cells

I am trying to use the "Update a row" element to find all the empty cells in one particular row and update them all to "x". I've tried in multiple ways and I just can't seem to ...
  • 23
0 votes
1 answer
45 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
3 views

Excel data and automatic email

I would like to optimise my excel spreadsheet Is there a scrips to in one Column according to the name selected from a drop down box an email would automatically be generated and sent to the relevant ...
  • 1
0 votes
0 answers
11 views

How extract data from Query Result in Excel from a Sharepoint List

Hi all not sure if this is even possible, but I have a Sharepoint List of all staff Details. I created a query from this into Excel, this all works correctly updates if something has changed in the ...
0 votes
0 answers
65 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
1 vote
0 answers
968 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
0 answers
31 views

Can you edit an embedded Excel sheet in Sharepoint Modern?

I want to embed several Excel spreadsheets into Sharepoint that allow any of the users who have access to the Sharepoint page to not only view them, but edit them in real time (and save). I know how ...
0 votes
1 answer
82 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
0 answers
175 views

Cannot open excel file on Sharepoint uploaded by Python

I couldn't open excel file on sharepoint(wrong file extension-> screenshot on below). I created code base on Postman API and then translated it to Python-Requests by code snippet. It is interesting ...
0 votes
0 answers
4 views

Search app in SP 2013 on premises and Data connection

Looking for a way to setup some sort of ability to search in SP page. I have an Excel data and Access 2003 db (sql feeds excel after some power queries it then feeds db). All 3 options are available ...
0 votes
0 answers
5 views

Excel Talley Button for Sharepoint

Is there is a way to replicate the talley button found in developer tools on Excel on share point. I have created a tracking sheet on excel using this button but now I need to make a co-author version ...
0 votes
0 answers
35 views

Export SharePoint Workflow Steps and Properties to Excel

I have four very detailed very long workflows currently now in SharePoint Designer that need to be migrated to PowerAutomate. Part of my process is to fully document my workflows outside of the system....
0 votes
1 answer
32 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
231 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
323 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 ...
  • 3
0 votes
1 answer
280 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
34 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
113 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 ...
  • 21
0 votes
0 answers
877 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
939 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 ...
  • 81
0 votes
1 answer
40 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
878 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) ...
  • 1
0 votes
1 answer
27 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?
  • 1
0 votes
1 answer
93 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
11k 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
148 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
36 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"...
  • 435
0 votes
1 answer
92 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 ...
  • 77
0 votes
1 answer
512 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
184 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 ...
  • 1
0 votes
1 answer
63 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
0 answers
107 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,204
1 vote
0 answers
53 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
0 answers
96 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
2 answers
56 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
1 answer
231 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 ...
  • 103
0 votes
2 answers
2k 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
1 answer
370 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 ...

1
2 3 4 5
17