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
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 ...
user avatar
  • 1
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, ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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....
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 3
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 1
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 21
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 125
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 ...
user avatar
  • 103
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&&...
user avatar
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 ...
user avatar
  • 1
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 ...
user avatar
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) ...
user avatar
  • 1
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?
user avatar
  • 1
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)....
user avatar
  • 1
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 ...
user avatar
  • 1
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 1
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"...
user avatar
  • 435
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 ...
user avatar
  • 57
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 ...
user avatar
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 ...
user avatar
  • 1
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 ...
user avatar
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?...
user avatar
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 ...
user avatar
  • 1,203
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 103
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar

1
2 3 4 5
17