Fix for SharePoint Datasheet Error: The list cannot be displayed in Datasheet view for one or more of the following reasons

When I try to open a SharePoint 2010 list in Datasheet View, It scolded me by throwing below error: The list cannot be displayed in Datasheet view for one or more of the following reasons:    – A datasheet component compatible with Microsoft SharePoint Foundation is not installed.    – Your Web…

Read more

How to Enable Anonymous Access in SharePoint?

How to enable anonymous access in SharePoint? To Enable Anonymous access in SharePoint 2010, We need to do the change in Central admin & Site collection: Step 1: Enable Anonymous Access in Central Administration: Go to: Central Administration > Application Management > Manage Web Applications, and Select your web application by highlighting…

Read more

Page Redirect using CEWP JavaScript in SharePoint

There are some situations, where we need to place re-directs in SharePoint pages. OK.. How to do that? How to redirect a SharePoint page? Simple! We can redirect using content editor web part in SharePoint. Just add a content editor web part, and place the below JavaScript code: This will redirect to…

Read more

Trick to Edit SharePoint List Forms to Add web part (NewForm.Aspx, EditForm.aspx, AllItems.aspx, etc.) in browser

By default, SharePoint doesn’t allow us to edit the List forms in browser. See the Edit Page from Site action is greyed out! However, Its possible to edit SharePoint list form pages! Here is the trick to edit SharePoint List Forms (like DispForm.aspx, NewForm.aspx, EditForm.aspx) in browser. Just append: &toolpaneview=2 in the…

Read more

List Aggregation-Rollup across site collections (Even across Farms) using Dataview and Web Services in SharePoint

With SharePoint web services and dataview web part, You can aggregate the lists/document libraries/etc between sub-sites/site collections/web applications/even across forms. So, here I’m going to walk through how to achieve this using a simple example. Let’s say I’ve two sites namely:  Site1  and Site2 and I have an Announcement List 1 in Site 1…

Read more