SharePoint Online: How to Open PowerPoint in Presentation Mode?

Requirement: Open PowerPoint files in slideshow mode in SharePoint Online. How to Open PowerPoint in Presentation mode from SharePoint Online? Any link to PowerPoint presentations (PPT, PPTX, or PPSX files) takes users to the Edit mode of the file. Even if the users don’t have permission to edit, SharePoint opens it in…

Read more

How to Add Calendar to SharePoint Online Modern Page?

Requirement: Display a calendar with a Month view on SharePoint Online home page. How to add calendar web part in SharePoint Online modern page? Although we have the events web part, it’s not giving a calendar look and feel, but it gets all upcoming events. So, to display a calendar grid view…

Read more

Batch Execute CSOM PowerShell Scripts to Avoid 429 Resource Throttling Issue in SharePoint Online

Problem: When performing bulk operations through CSOM PowerShell scripts, SharePoint Online throttles the requests with an error message, “The remote server returned an error: (429).” How to Execute CSOM PowerShell Script in Batches? Say, You want to create 1000 items in a List. Wouldn’t it be better to send 10 requests of…

Read more

Open a Document in Browser instead of Client Application in SharePoint Online

Requirement: Open documents in the browser in SharePoint Online. How to Force Documents open in Browser instead of the Client Application? The “Open Documents in Client Applications by Default” feature and the library settings “Opening Documents in the Browser” decide whether a document should be opened in the web browser or in…

Read more

How to create a Subsite Even If the subsites creation is disabled in SharePoint Online?

Update: Things are changed now! You can’t create a subsite if the subsite creation is disabled on the Admin Center! If you try to create a subsite through web browser, You’ll get “New subsites are not available for your organization. Create a new site instead.” message and PowerShell says “New subsites are…

Read more

The Ultimate List of SharePoint Online URL Shortcuts!

Here is the list of handy shortcuts to frequently accessed SharePoint Online URLs! Just append it to your site URL. E.g., https://yourdomain.sharepoint.com/sites/SiteName/_layouts/RecycleBin .aspx Page URL Access Requests /Access Requests/pendingreq.aspx?mbypass=1 Add an App (Classic) /_layouts/addanapp.aspx Admin Recycle Bin /_layouts/AdminRecycleBin.aspx Apps (to configure App Catalog, etc) https://<<Tenant>>-admin.sharepoint.com/_layouts/15/online/TenantAdminApps.aspx Change Site Master Page /_layouts/ChangeSiteMasterPage.aspx Change the…

Read more

SharePoint Online: How to Allow Edit Permissions but Not Download?

Requirement: Allow edit but not download in SharePoint Online. SharePoint Online: How to Allow Edit but not download? We wanted to provide edit permissions to users on an Excel spreadsheet stored in the SharePoint Online document library, without giving them the ability to download the file! So, how to provide users the…

Read more

How to Disable Export to Excel Button in SharePoint Online?

Requirement: Disable Export to Excel in SharePoint Online. How to Disable Export to Excel in SharePoint Online? The Export to Excel button located on the toolbar can be useful for exporting data from your SharePoint lists and Libraries to an Excel spreadsheet. However, sometimes you may not want others to be able…

Read more

How to Embed Excel Spreadsheet to Modern SharePoint Online Pages?

Requirement: Display Excel Spreadsheet in SharePoint Online. SharePoint Online: How to Embed an Excel Spreadsheet? We don’t have Excel Web Access Web Part in modern SharePoint Online sites that integrate an Excel sheet into SharePoint pages. However, we can use the Embed web part to display an Excel spreadsheet in SharePoint Online:…

Read more

SharePoint Online: Link to Force Download a Document Instead of Open

Requirement: Force download a file instead of opening in SharePoint Online SharePoint Online: URL to Document Download Instead of Open Documents linked in SharePoint Online pages, navigation menu, lists, etc. open in the browser (or in client application!) directly either in Read-only mode or in Edit mode, based on user permissions. What…

Read more