Questions tagged [excel-online]
Microsoft Excel Online is the free version of Excel that works in your browser. It's a companion app to Excel, designed to let you view and edit your Excel spreadsheets online.
29
questions
0
votes
0
answers
75
views
Export the large dataset into Excel file using power automate
I have large dataset which is having more than 50000 items. Need to export that into excel file using power automate. can some one suggest me on this?
- 77
0
votes
0
answers
1k
views
Best way to format null dates when using power automate to transfer excel rows to SharePoint List?
I’m needing a flow to complete these actions:
List all rows from an excel file
Put the values stored in each of the Excel rows and put them in a SharePoint List
If a row is already in the SP list, ...
0
votes
0
answers
27
views
Linking Excel Spreadsheets on SharePoint
I have a SharePoint site that has a folder for each department. The departments only have access to their folder. Each folder has a spreadsheet that uses vlookup to reference a master spreadsheet on ...
- 1
0
votes
1
answer
406
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
33
views
Deal with the limitation of 1600 requests to Excel API via Power Automate
I use Power Automate to get rights per file on that file creation in SharePoint, based on the file name. Say if filename contains [email protected] John will get the read rights on that file.
...
- 133
1
vote
1
answer
661
views
Excel Online on SharePoint/OneDrive - Error message: "We ran into a problem completing your request. Please try that again in a few minutes."
I've got an Excel sheet saved on OneDrive for Business. Accessing it through a SharePoint web interface lets multiple users edit it at the same time.
It's worked great for a year, then last month we ...
- 11
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
0
answers
2k
views
Converting CSV files to Excel workbook via Power Automate
hope you're all doing good.
I created a form with PowerApps. On this form i have a button that i can use to convert the content of my form into a CSV file (in reality, it's a tabbed form so the flow i ...
- 23
0
votes
1
answer
55
views
What is the best way, to get the properties and the name of three files, present in three separate folders, on a SharePoint online site?
I am recently experimenting with Microsoft Power Automate a lot and I am trying to tackle the following problem.
Let's imagine that you are present in a SharePoint online folder, and in this folder ...
- 105
0
votes
1
answer
4k
views
Is it possible to merge three Excel sheets into one using Microsoft Power Automate?
I am experimenting with Microsoft Power Automate but quite recently I encountered a problem which is too complex for me to solve.
I have three Excel sheets in three separate folders on my SharePoint ...
- 105
0
votes
2
answers
369
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 ...
- 1
0
votes
0
answers
67
views
How to automate incoming emails with Power Platform to notify and visualize tabular information with PowerApps?
I am trying to automate the incoming mail with Power Automate so when a mail arrives with a specific subject I extract the data and save it in an excel file. Power Apps would have this excel as a data ...
0
votes
2
answers
2k
views
Create table from excel file in an email with MS Flow and Sharepoint
I'm trying to get the data from the attachment of an email which is an Excel file, I want to get the data in order to create a table so SharePoint can handle the data, so far this is what I have:
But ...
1
vote
2
answers
657
views
With Sharepoint hosted Excel file I'm getting the error message "trouble signing in" when trying "Open in Desktop App"
I'm unable to Open any Excel files on my Desktop Excel App from Sharepoint "Open in App" or Excel online "Open in Desktop App".
I'm able to log into my company's Sharepoint, and ...
- 121
0
votes
2
answers
349
views
Cannot edit Document Template of Library
today I tried to change my custom Document Template for one of my Sharepoint Librarys.
(So everytime someone click on new Excel File, he opens this template)
Unfortunately its not longer possible to ...
0
votes
1
answer
335
views
Disable SharePoint Online Real Time Save on Excel Document
Is it possible to disable the in browser real time auto save that SharePoint Online has for Excel documents(or any O365 app) that are stored on it? I have a Excel document that I essentially want any ...
- 23
0
votes
0
answers
830
views
Error: The data connection uses Windows Authentication and user credentials could not be delegated
Environment: SharePoint 2016 (On-prem) with on-prem Office Online
When users attempt to navigate to an Excel file with an embedded datasource, they receive the following error:
The data connection ...
- 111
0
votes
0
answers
818
views
Is it possible to update a sharepoint list when an item is created or modified in excel using microsoft flow?
I am trying to build a flow which will update a sharepoint list when a row is created or modified in excel. I tried the flow as shown below but it step "condition" gives result as false even when ...
- 79
0
votes
0
answers
98
views
Excel file saved as htm to render properly when uploaded in SharePoint library
I use DriveToWeb to host a webpage (and supporting files) with OneDrive. My website is basically an Excel file saved to .htm file so it has supporting files.
Why do I save Excel files to .htm files ...
- 33
0
votes
2
answers
4k
views
the requested range does not exist in the sheet
When i'm trying to open an excel File in Excel Online, i get this error!
"the requested range does not exist in the sheet"
I can't open the file.
How i can fix it please?
- 523
0
votes
1
answer
236
views
How to open an Excel file in Excel online on button click in SharePoint Online?
I need to open an excel file in Excel online on a button click which I retrieves from Document library .
I have followed this, but it shows me an Error page like 'Item does not exist. It may have ...
- 144
1
vote
1
answer
23
views
Limiting editing access and setting up permissions so users can create new records but cant see the whole sheet
I am hoping that excel online can become a new system for entering in daily time for our company. id like to set it up so that our field crews can enter in their daily time on an excel online sheet ...
- 11
1
vote
1
answer
27
views
How generate link for office 365 online for ALL items in a folder, in a quickly way
i try to explain my issue.
I created a folder in sharepoint then added some excel file (xls).
Now i want to export the list of the link of all items, but NOT in that way
https://mywebsite....
- 11
1
vote
1
answer
583
views
Excel file locked by another user
I have an Excel file shared widely on SharePoint. Most users open the document with Excel Online. A couple times, I've seen when a user opens it with the Excel client, it then locks the file for ...
- 172
0
votes
1
answer
689
views
Can't update data Excel Online from Azure SQL datasource
Here's what I've done:
Created new Excel file on my desktop. Added connection to Azure SQL using database authentication. Read in a view.
Save this document to Sharepoint for my tenant. It's hosted ...
- 101
0
votes
2
answers
5k
views
Open a specific Workbook in Excel online using the URL in SharePoint online Excel Workbook
I have 2 sheets inside the excel file i just want to link different sheet using url in different page is there any way that i can open the specific sheet of excel file using the url in the browser i ...
- 337
1
vote
1
answer
2k
views
Exporting calender from share point to Excel
When I export calendar from share point to excel, I could only see data for one month (current month) in the excel. But, I want to see the data for complete year in the calendar exported to the excel.
...
2
votes
2
answers
3k
views
How does co-editing a Sharepoint Excel Online document work?
If I'm using an Excel workbook and editing in the browser (not downloading the document to my PC to make changes offline), will I know if someone else is also editing it at the same time?
Will the ...
- 21
2
votes
0
answers
836
views
Reading an excel file from Sharepoint online using REST and the Microsoft Graph API
Is it possible to read an excel file from Sharepoint online using REST and the Microsoft Graph ? I need to retrieve a column field using javascript/Jquery
Any feedback will be really appreciated
- 4,226