Manage access requests in SharePoint 2010

‘Manage access request’ is an old mechanism which was present in MOSS2007 and with no surprise Microsoft has continued the same feature in SharePoint 2010.

Let me tell you guys that this feature is very important from so many perspectives:

§  There might be so many site collections administrators are assigned but you can specify any user or you can call as POWER USER who has the responsibility to approve the access request.

§  You can specify anybody, but make sure that he has a thorough knowledge of the functionality as it might be a threat to your site security because your site might contains some confidential documents that you don’t want to explore any third party user.

§  You are maintaining a proper channel as well as record by which to whom you are approving or whom you are giving access denied.

§  This might be a part of your governance project model also

The access request feature allows people to request access to content that they do not currently have permission to see. As a site owner, you can configure the feature to send you mail when someone requests access to a site.

Where is the location of this functionality in SharePoint 2010?

How to enable ‘manage access request’ in SharePoint 2010?

Here are the detail steps:

1.   Open the site collection on which you are working.

2.   Site actions

3.   Site settings

4.   Under ‘users and permissions’ section

5.   Site permissions

6.   Please refer the Ribbon on the top

7.   Permission tools

8.   Manage access requests

9.   Select the checkbox ‘allow request for access’ and enter the appropriate email id as per your requirements and click OK

That’s it- We are done!

If you have any queries/questions regarding the above mentioned information then please let me know, Thank you.

error while opening excel files in SharePoint 2010

I am using SharePoint 2010 and when users click on an .xlsx document in a document library it throws the following error message:

following features that are not supported by Excel in the browser:

• Data validation

• Sheet protection

Would you like to try and open this file in Excel?

Learn more about unsupported features

Number of things to check or troubleshooting steps to find out the culprit:

<!--[if !supportLists]-->1.   <!--[endif]-->Make sure that this file is not broken. Download a copy of this file and edit it Excel client. Remove the Consolidation, Data sources and Data validations on the file to have a test whether it fixes this issue.

<!--[if !supportLists]-->2.   <!--[endif]-->Check the event viewer and try to find out the exact error information as it will give you the account name where the problem lies.

<!--[if !supportLists]-->3.   <!--[endif]-->Check the SharePoint ULS logs where it will show the exact root cause.

<!--[if !supportLists]-->4.   <!--[endif]-->Check the supported and unsupported features: http://msdn.microsoft.com/en-us/library/ff595319%28v=office.14%29.aspx

<!--[if !supportLists]-->5.   <!--[endif]-->If you getting this error while trying to view the excel file in browser mode then please have a look on this article:

http://office.microsoft.com/en-us/sharepoint-server-help/differences-between-using-a-workbook-in-the-browser-and-in-excel-HA010369179.aspx#_Toc240268532

<!--[if !supportLists]-->6.   <!--[endif]-->If there are unsupported features then you need to remove it before uploading that excel file in SharePoint document library.

<!--[if !supportLists]-->7.   <!--[endif]-->You can define in the library settings whether or not to open documents in the browser or the client application. The default is set on the server, but you can overrule that at the library level. Since Excel Services cannot open workbooks with data validation, graphic object or VBA, many Excel files with basic functionality simply won't load in the browser.

<!--[if !supportLists]-->8.   <!--[endif]-->Make sure that you are using 32-bit version of IE- Microsoft Recommended. - This is very important as it resolves most of the issues.

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Request: If you have any other resolution then please share so that it would be helpful for the entire community, Thanks again!

SharePoint 2010 august cumulative update

The product group released the August 2013 Cumulative Update for SharePoint 2013 product family.

The KB articles for August CU will be available at the following locations in a couple of days:

KB 2817517 - SharePoint Foundation 2013 August 2013 CU

KB 2817616 - SharePoint Server 2013 August 2013 CU

KB 2817615 - SharePoint Server 2013 with Project Server August 2013 CU

KB 2817521 - Office Web Apps Server 2013 August 2013 CU

The Full Server Packages for August 2013 CU are available through the following links:

Download SharePoint Foundation 2013 August 2013 CU

Download SharePoint Server 2013 August 2013 CU

Download Project Server 2013 August 2013 CU

Download Office Web Apps Server 2013 August 2013 CU

After installing the fixes you need to run the SharePoint 2013 Products Configuration Wizard on each machine in the farm.