Questions tagged [excel]
Microsoft Excel is a commercial spreadsheet application, which can be integrated with SharePoint.
843
questions
0
votes
0
answers
10
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 ...
0
votes
0
answers
25
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
11
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
0
answers
11
views
I want to access the first page of an excel workbook [closed]
Import-Csv C:\Users\_____\Desktop\Powershell_Renaming\list.csv | % { Rename-Item -Path $_.Name -NewName "$($_.Newname)" }
This is currently what I use for file changing but I was wondering ...
0
votes
1
answer
14
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
21
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
3
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
11
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
29
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
16
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
0
answers
14
views
Map excel column with complicated formula in power app table
I have an Excel column containing complicated formula (if statement, concatenate, VLOOKUP), and I need to create this column in Dataverse (solution table in Power apps). Since it's not just a ...
0
votes
2
answers
44
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
64
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
23
views
Open Excel template on desktop as a new document
My company is trying to manage our spreadsheets we use company wide for engineering/design. Our goal is to create a document library that holds these as templates which our engineers can open directly ...
0
votes
0
answers
17
views
Excel - Allow Edit Ranges - Select Sharepoint Users
I am using a combination of Protected Sheets and 'Allow Edit Ranges' to lock down an Excel Workbook; however I want to move away from specifying individual passwords for each Edit Range and instead ...
0
votes
0
answers
26
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 ...
0
votes
0
answers
20
views
SharePoint File Viewer: opening a file on a specific sheet with a specific collapsed section
I have created a master file with all of our objects documented on separate sheets. The first sheet has the table of content for the file. The separate objects are grouped according to the projects ...
2
votes
0
answers
31
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
10
views
Export list data to excel through a custom web part
Using SharePoint 2013 here, does anyone know how I may be able to create a custom Web Part to export a list to an Excel file? Users have moved to Chrome and now get the "Microsoft SharePoint ...
0
votes
0
answers
9
views
When clicking to open a document status will turn pending
Every time I want to open a word or excel sheet in library, approval status turns to pending without checking out the document. Lots of documents showing pending waiting for approval when no changes ...
0
votes
0
answers
292
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
1
answer
232
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
0
answers
48
views
SharePoint hyperlinks in Word or Excel don't work
[SharePoint 2013/Office 2016-2019]
I try to promote the usage of hyperlinks in documents (Word, Excel) as people tend to use a not clickable short path. I did the configuration for activating Document ...
0
votes
1
answer
26
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
0
answers
19
views
Linking information in excel attachment on SharePoint to the list item or vice versa
I've been breaking my head over this part for some time now. Hopefully the people on this forum can help me steer in the right direction.
I created a SharePoint List where people can place their seed ...
0
votes
0
answers
13
views
Excel running power query must be able to access invisible excel file in sharepoint
basically I have a large file with a ton of content in sharepoint and each department has their own client version running power query to get what they need.
In order for it to work, I have to give ...
0
votes
1
answer
314
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
20
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
0
answers
7
views
Refreshing AAS data in a workbook in SharePoint Online
I need to allow external/guest users access to an Excel document with a connection to AAS stored on SharePoint Online (SPO) using Excel for the web.
I have data stored on Azure Analysis Services (AAS)....
0
votes
0
answers
8
views
Excels graphs don't refresh in SharePoint
We are using our Excel in SharePoint.
In SharePoint I can’t “Refresh connections”. I receive an error message. So the pivot tables and graphs do not update.
How can I fix this error?
See attached ...
0
votes
1
answer
25
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
8k
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
24
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
0
answers
35
views
How to host a htm page with SharePoint when the files are generated from excel. (Cant change them into aspx..)?
Is there a way to host static html using Office 365 sharepoint?
Hello dear community, i have a similar problem....
(Please only real comments... i dont known what to do for weeks.
Okay... i want to ...
0
votes
2
answers
17
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
40
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
230
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
59
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 ...
0
votes
0
answers
46
views
while reading excel from map folder error: failed due to the following error: 80080005 Server execution failed While Opening Excel App From C# Code
While trying to read excel file in C# console application, i am getting following error:
"Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed ...
0
votes
1
answer
34
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
33
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
vote
0
answers
24
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
36
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
41
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
39
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 ...
0
votes
2
answers
755
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
164
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 ...
0
votes
1
answer
63
views
Files uploaded in SharePoint Online differ from original
currently using Office365-REST-Python-Client to upload files into SharePoint Online instances, mainly Excel files (xlsx and xlsm). They are uploaded and downloaded just fine, but now I am noticing ...
0
votes
1
answer
35
views
SharePoint file updates reminder/push notification questions
I have an Excel sheet (worklog) in my SharePoint folder, I wonder if it is possible to have a feature that:
Send a push notification/or reminder to remind the people having access to the Excel sheet ...