Fix “Connect-SPOService : Current site is not a tenant administration site.” Error in SharePoint Online Management Shell

Problem: When trying to connect to SharePoint Online using SharePoint Online Management Shell, I got an error message: “Connect-SPOService : Current site is not a tenant administration site.” Root Cause and Solution: The script was trying to connect to SharePoint Online as: “Connect-SPOService -Url https://crescent.sharepoint.com”, But the problem is: It should connect…

Read more

SharePoint Online: Fix “An error occurred while enumerating through a collection: The collection has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested” in PowerShell

Problem: Error in SharePoint Online CSOM PowerShell script:“An error occurred while enumerating through a collection: The collection has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested” Root cause: The error “An error occurred while enumerating through a collection:…

Read more

SharePoint Online: Fix “The collection has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested” Error in PowerShell

Error: The collection has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested. Root Cause: You must load the object before you try to retrieve its properties! Solution: The “The collection has not been initialized. It has not been…

Read more

SharePoint Online: Fix “The remote server returned an error: (403) Forbidden.” Error in PowerShell

Error: Exception calling “ExecuteQuery” with “0” argument(s): “The remote server returned an error: (403) Forbidden.” in PowerShell scripts for SharePoint Online. Troubleshooting Checklist for 403 forbidden in SharePoint Online PowerShell: The “The remote server returned an error: (403) Forbidden.” error can occur when connecting to SharePoint Online using PowerShell. This error typically…

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 Web Part helps display an Excel workbook on SharePoint pages, and it’s available only in the SharePoint Enterprise edition (and in Office 365, It’s only available on the Enterprise Plans E3 and E4). If you are using the…

Read more

Content Editor, Script Editor Web Part Missing in SharePoint Online?

Problem: The content Editor Web Part in SharePoint Online is missing! Fix SharePoint Online Content Editor web part missing Issue: In Modern SharePoint Online sites (E.g., Group sites, Communication Sites), Self-serviced sites, and Root site, custom scripting is disabled by default! So, how to get a content editor web part in SharePoint…

Read more

Fix SharePoint Online “The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.” in PowerShell

Problem: When trying to get list items from a SharePoint Online list through PowerShell, I got this error message:Exception calling “ExecuteQuery” with “0” argument(s): “The attempted operation is prohibited because it  exceeds the list view threshold enforced by the administrator.”At line:26 char:5+     $Ctx.ExecuteQuery()+     ~~~~~~~~~~~~~~~~~~~    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException    +…

Read more

PowerShell: Batch Process Large Lists to Fix “The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.” Error in SharePoint

Problem: When working with large lists > 5000 list items, any operation such as Read/update/delete is controlled by the list view threshold. You get an error message when you try to handle large list items: The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator. Solution:…

Read more

SharePoint Online: “Save Site as Template” Link Missing? Here is How to Enable!

Problem: “Save Site as Template” option is missing in SharePoint Online! The “Save Site as Template” option is unavailable on Office 365 group-connected and Communication sites! However, there is another reason why you don’t see the “Save site as Template” link under site settings: Custom script disabled! How to Enable Save Site…

Read more