How to Create Calendar Overlay in SharePoint Online?

What is Calendar Overlay in SharePoint Online? Calendar overlay is a cool feature in SharePoint that lets you layer the contents of multiple calendars into a single easy-to-read, color-coded calendar view. Use it when you are managing more than one calendar in your SharePoint environment but want to create a consolidated view…

Read more

Add Active Directory Group to SharePoint using PowerShell

Requirement: Add Active Directory Group to SharePoint Group using PowerShell How to Add Active Directory Group to SharePoint? To add AD group to SharePoint, do the following: Navigate to your SharePoint site and click on the Site Settings gear icon >> Select “Site settings” Click on the “People and groups” link under…

Read more

How to Download a File from SharePoint Library using PowerShell?

Requirement: Download a File from SharePoint Document Library using PowerShell How to Download a File from a Library in SharePoint? Users can download copies of files from the SharePoint libraries to another location such as the local computer or any accessible network file share. To download a copy of a file from…

Read more

Limited-access user permission lockdown mode Feature in SharePoint

What is limited-access user permission lockdown mode? In SharePoint, users are assigned to the “Limited Access” permission level automatically when the account is granted exclusive access (unique permission) only to resources such as list/library/document, etc within the site, but not directly to the site itself. E.g. When you grant access to a…

Read more

PowerShell to Update Permissions for Custom Permission Level in SharePoint

Requirement: Update permission level in SharePoint using PowerShell How to Edit a Permission level in SharePoint? To edit an existing permission level in SharePoint, follow these steps: Permission levels are scoped at site collection. So, Navigate to the SharePoint site collection where you want the permission level to be edited. Click on…

Read more

Download All Files in a SharePoint Document Library using PowerShell

Requirement: Download all files in document library in SharePoint Download All Documents in a Library using PowerShell: Here is the PowerShell to download all files in a document library.  Download All Document Libraries from a SharePoint Site: How about downloading all files from all document libraries from a SharePoint site?

Read more

PowerShell to Delete All Files in SharePoint Document Library

Requirement: Delete All Files in SharePoint Document Library using PowerShell SharePoint PowerShell to Delete All Documents To delete all documents in SharePoint library, use this PowerShell: Please note, this script sends all files from all folders-sub folders in a library to recycle bin. If you want to permanently delete files use: $File.Delete()…

Read more

How to Display Charts in SharePoint using Excel Web Access Web Part?

Requirement: Display Excel Chart in SharePoint Online How to Show Excel Charts & Graphs in SharePoint Online using Excel Web Access Web Part? Excel Web Access web part in SharePoint Online can be used to display charts. To display the Excel sheet with charts in SharePoint: Create an Excel sheet with Chart…

Read more

Excel Web Access Web Part Missing in SharePoint Online?

Problem:  Excel Web Access Web Part Missing in SharePoint Online Solution: Excel Web Access is available only in SharePoint Enterprise edition (and in Office 365, It’s only available on the Enterprise Plans E3 and E4).If you are using Enterprise edition, make sure you have “Enterprise Site Collection Features” enabled. Here is how…

Read more