SharePoint Archives - Data Cornering

by Janis Sturis November 18, 2020 Comments0

Set Excel file read-only MS Teams, OneDrive, or SharePoint

Here is how to set Excel file read-only when using in MS Teams, OneDrive, or SharePoint. Those environments are different in the possibilities…

by Janis Sturis November 15, 2020 Comments0

Here is an example of how to automatically download files from SharePoint Online by using PowerShell. By knowing how to run PowerShell script…

by Janis Sturis October 30, 2020 Comments0

Here is an example of how to automatically upload files to SharePoint Online by using PowerShell. By knowing how to run PowerShell script…

by Janis Sturis October 29, 2020 Comments0

There is a couple of ways how to connect to the SharePoint file with Power Query, but first of all, I recommend the…