Composed Look Feature in SharePoint

Themes are the quick and easiest way to apply branding to SharePoint sites. Themes got changed over time in SharePoint’s history. Now from SharePoint 2013, Themes are redesigned as the “Composed Look” feature. As it sounds “Composed” look, it simply defines theming by combining design elements: Master page – AKA site layout,…

Read more

Delete Unique Permissions (Reset Broken Inheritance) in SharePoint 2013 using PowerShell

We have got a requirement to reset customized permissions of a large set of SharePoint libraries and documents. We can reset the permission inheritance and delete unique permissions for a site/web/folder/item level where the inheritance is previously broken. E.g. for a library: Go to your library, click on Library Settings. In the…

Read more

How to Create Federated Search Results in SharePoint 2013?

What is Federated Search in SharePoint 2013? As its name suggests, Federated search combines search results from multiple search engines. Federated search allows you to consume search indexes created by search engines outside of SharePoint. How does the Federated Search work in SharePoint 2013? Federated Search basically uses the index created by…

Read more

Sorry, something went wrong – The file FILENAME is locked for exclusive use by USER

Problem:  End-Users receives error when trying to edit a file. “Sorry, something went wrong – The file FILE-URL is locked for exclusive use by USER-NAME” Root Cause:When users edit the document in client applications such as Microsoft Office, SharePoint places a lock and renews it every 10 minutes to prevent other users…

Read more

Reset to Site Definition via PowerShell in SharePoint

To Re-ghost customized SharePoint sites and pages, We use “Revert to Site definition” via Site Settings >> under Site Actions section, click on Reset to site definition  Choose a specific page or entire site. Click on Reset! . Reset to site definition – what does it do?Reset to Site Definition removes any…

Read more

Configure SharePoint 2013 Object Cache Super User, Super Reader Accounts

SharePoint 2013 object cache stores metadata about SharePoint Server objects like SPSite, SPWeb, SPList, etc. on the Web Front Ends. SharePoint features such as publishing, content query web part, navigation, search query box , metadata navigation, etc fetches data from object cache, instead of hitting SQL Server when data needs to be…

Read more

The document could not be opened for editing. A Microsoft SharePoint foundation compatible application could not be found to edit the document

Problem:  When trying to edit an Excel sheet from SharePoint 2010 document library, user received this error message – “The document could not be opened for editing. A Microsoft SharePoint foundation compatible application could not be found to edit the document” Troubleshooting Check List: As the error message says, You must have…

Read more

Migrate SharePoint Users from One Domain To Another using Move-SPUser

Requirement: During a acquisition, Our company decided to merge with an acquired company’s AD by re-creating their user Ids in our AD. Also, the acquired company had a bunch SharePoint sites and we wanted to migrate them to our SharePoint environment. That brought another challenge of re-mapping user Ids with permission between…

Read more

Fix “This workbook cannot be opened because it is not stored in an excel services application trusted location” Error in SharePoint 2010

Problem: Got this error when trying to open an Excel Sheet stored in a SharePoint 2010 document library: “This workbook cannot be opened because it is not stored in an Excel services application trusted location. To create an Excel Services Application trusted location, contact your system administrator”. Solution: By default, Excel Services…

Read more

Get All Users of SharePoint Farm-Web Application-Site Collection-Site using PowerShell

Requirement: Get all users of SharePoint Farm. SharePoint PowerShell to Get All Users in Farm PowerShell script to get all SharePoint users at Farm-Web Application-Site Collection-Web levels: This script can be used to get all users in site collection and export all users to excel. Get All Unique Users in SharePoint Farm…

Read more