Questions tagged [excel]
Microsoft Excel is a commercial spreadsheet application, which can be integrated with SharePoint.
855 questions
0 votes
0 answers
22 views
How can I open a SharePoint URL in a desktop application, without stopping over at a Web browser?
This may not be on-topic for this particular StackExchange; if not, then I apologize, and would ask to be directed to a more appropriate location. When I receive an invitation via E-mail to view a ...
0 votes
0 answers
17 views
some CreatedDate in excel are showing wrongly as mm/dd/yyyy instead dd/mm/yyyy
I have this workflow to get items from sharepoint and build an excel sheet file and table:- Inside "Select related Data 2' i am using this format for the created date if(empty(item()?['Created'])...
0 votes
0 answers
11 views
How does SharePoint provide access to Excel files?
We have an application (similar to SharePoint) that is providing access to Excel files via https. However, whenever we tell Excel to open a file (via https), it will only allow ReadOnly access ...
0 votes
0 answers
22 views
Connect to Success Factor
I would like to build a power automate cloud flows where I can be able to fetch the data using OAuth out of success factors (SAP) and load them to excel worksheet via PA cloud flows, since this is new ...
- 171
0 votes
0 answers
35 views
VBA enabled sheets in desktop app not saving to sharepoint correctly
We have some spreadsheets that have quite a bit of VBA coding in them. I have all the users opening in the desktop excel application in order to ensure all the code works correctly. However we are ...
0 votes
0 answers
52 views
How to insert an Interactive Excel Chart with slicers and timeline?
I have some pivot charts I'd like to present in a Sharepoint. I tried embedding the workbook and using a File Part, but despite enabling interaction, the display is absolutely unprofessional and ...
0 votes
1 answer
512 views
Power Automate - Compare column from excel with column from SPO list and update SPO list
I have an excel spreadsheet with two columns named "Document ID" and "RouteDate". The Id column has unique values. I also have an SPO list named "Site Records" with the ...
0 votes
2 answers
71 views
How can I update data in a SharePoint list via Connection in Excel?
I have a Connection to a SharePoint list and, accordingly, a table in Excel that contains data from SharePoint. Let's say I add a new row of data to this table. How can I sync my table with SharePoint?...
0 votes
0 answers
356 views
Data changes taking a long time to show/update when using Excel as Data source in Power Apps
I have a Power Apps with an Excel file as a data source. The Excel file has about 75,000 rows of data in it. The data inside the excel file are user emails (each one is a unique email) and various ...
- 1
0 votes
1 answer
194 views
Co authoring in Excel and Word when using SharePoint 2016 and Microsoft 365 (Formerly Office 365) client
As per this article, Excel for Microsoft 365 does support co-authoring and every user must use same version. https://support.microsoft.com/en-us/office/excel-file-is-locked-for-editing-6fa93887-2c2c-...
- 3,728
0 votes
0 answers
46 views
A list created from Excel Export creates a allitemsg.aspx view and also goes to Edit mode
I think is easier to create and build columns using Excel formulas in Excel. So, I Export from a Excel table to create a new sharepoint list, but it gets a default view called allitemsg.aspx? I much ...
- 1
0 votes
1 answer
150 views
Getting Access denied when users trying to access word or excel document on SharePoint Server Subscription Edition on-premises
We are on SharePoint Server Subscription edition on-premise. We are seeing "Access denied contact administrator" when users are trying to access word/excel files. when we checked logs I can ...
- 1,417
0 votes
0 answers
426 views
Javascript error when browse SharePoint libraries within Office clients
When we open or save files in a SharePoint library from within Word, Excel or other client applications, we get javascript errors in the browse window. There are always two errors, one from init.js ...
- 87
0 votes
1 answer
767 views
Power automate flow - cached data issue
In my flow I'm extracting data from excel file located on sharepoint and then I'm inserting it to sql server database, after that file is moved to another location. First execution is working fine, ...
0 votes
1 answer
3k views
Get items and get files (property only) Is just Returning Path in output not file names
The overall purpose of the flow is to add the appropriate metadata to the corresponding columns based on the name of the document located in an Excel file. Steps: The flow is initiated manually. Upon ...
- 155