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/2016 using PowerShell

We have 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 settings…

Read more

How to Create Federated Search Results in SharePoint 2013 / 2016?

What is Federated Search in SharePoint? 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 another…

Read more

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

Problem:  End-Users receive errors 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

Configure SharePoint 2013 / 2016 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., fetch data from object cache, instead of hitting SQL Server when data needs to be retrieved…

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, the 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 an 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 number of SharePoint sites, and we wanted to migrate them to our SharePoint environment. That brought another challenge of re-mapping user Ids with permission…

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 Do you want to get a list of all users in your SharePoint farm? PowerShell can help you with this! This blog post will show you how to use PowerShell to quickly find all users in your…

Read more