Export to Excel issue with Person or Group Column

Only solution to the problem:

Remove "Multi-Select" choice of column based on the "Person or Group" column type.

This solution is tested with MOSS 2007, Excel 2003 and higher.

How to enable anonymous access in SharePoint 2010

1- Open Central Administration
2 - From the left menu select "Security"
3 - Under "General Security" select "Specify authentication providers"
4- Make sure that your site is selected and click on "Default" link
5- Under "Anonymous Access" select "Enable anonymous access" checkbox
6- Open your site
7- From site actions menu select "Site Settings"
8- Under "Users and Permissions" select "Site permissions"
9- Click on "Anonymous Access" from the ribbon
10 - Select "Entire web site" Or "Lists and libraries"
11 - Click "Ok"
12- Enjoy

Read more..

How to hide ribbon row when enabling anonymous access in SharePoint 2010

When you enable anonymous access to your site the ribbon row will appear for anonymous users but without "site actions" menu and it will be "Login" link but if you need to hide all this row you have to do the following:

1- Open your masterpage with SharePoint designer
2- Find the ribbon row Search on "ribbonrow"
3- before the div that holds the ribbon add this tag

<sharepoint:spsecuritytrimmedcontrol id="SPSecurityTrimmedControl2" runat="server" permissionsstring="ManageSubwebs">

4- after the end of the ribbon div close the security tag

</sharepoint:spsecuritytrimmedcontrol>
5- Enjoy

Read more...