SharePoint 2010 Service Pack 2 Released

Access 2010 Runtime SP2	KB2687444	32-bit	64-bit
Duet Enterprise for Microsoft SharePoint and SAP SP2	KB2687445		64-bit
FAST Search Server 2010 for SharePoint SP2	KB2687446		64-bit
Groove Server 2010 SP2	KB2687448		64-bit
Office 2010 Filter Pack SP2	KB2687447	32-bit	64-bit
Office 2010 Language Pack SP2	KB2687449	32-bit	64-bit
Office 2010 SP2	KB2687455	32-bit	64-bit
Office Language Interface Pack 2010 SP2	KB2687450
Office Proofing Tools 2010 SP2	KB2687458	32-bit	64-bit
Office Web Apps 2010 SP2	KB2687470		64-bit
PowerPoint Viewer SP2	KB2687456	32-bit
Project 2010 SP2	KB2687457	32-bit	64-bit
Project Server 2010 SP2	KB2687452		64-bit
Search Server 2010 SP2	KB2687461		64-bit
Server Language Pack SP2	KB2687462		64-bit
SharePoint 2010 Indexing Connector for Documentum SP2	KB2687459		64-bit
SharePoint Designer 2010 SP2	KB2687463	32-bit	64-bit
SharePoint Foundation 2010 Client Object Model Redistributable SP2	KB2687467	32-bit	64-bit
SharePoint Foundation 2010 Language Pack SP2	KB2687466		64-bit
SharePoint Foundation 2010 SP2	KB2687464		64-bit
SharePoint Server 2010 SP2	KB2687453		64-bit
SharePoint and Project Server 2010 SP2	KB2687452		64-bit
Visio 2010 SP2	KB2687468	32-bit	64-bit
Visio Viewer 2010 SP2	KB2687469	32-bit	64-bit

Change Regional settings in Central administration as well as at the site collection level- SP2010

Regional settings plays a very vital role as the SharePoint has been extensively used all over the world with different languages.

So many requirements can arise such as:

-How can we set the default regional settings for the new site collections?

-How can we change the default regional settings once the site collection created?

-How can we change the default time zone?

-How can we change the default calendar?

-How can we set the alternate calendar?

-How can we change the time format? 12 hour/24 hour?

Primarily we are going to focus as how we can change the regional settings in central administration as well as at the site level.

Change Time Zone settings in Central Administration:

-Open the central administration

-Application management

-Manage web applications

-Select the appropriate web application on which you need to change the default regional settings

-General settings from the top dropdown

-Default time zone

-change it as per your requirement.

Change Regional settings at the site collection level:

-Open the site collection

-site actions

-site settings

-site administration

-Regional settings

-change any settings as per your requirements.

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.

import Spreadsheet failed into SharePoint as a list - SharePoint 2010

Problem Description:

I had one user who was not able to Import an excel spreadsheet into SharePoint as a list.

Error Message:

You are not authorized to view this page.  

You might not have permissions to view this directory or page using the credentials you supplied.

HTTP Error 403 - Forbidden

Troubleshooting Done:

-User is a site collection administrator.

-We got the file at our end and checked it worked fine.

-We also checked with the proxy settings but even after changing it to the same as we had it did not work.

-Asked the user to check from a different machine with his login it worked fine

-As it was related to excel tried checking on Microsoft office Diagnostics available in Office 2007.

And to my amaze it worked. We were able to import the spreadsheet without any issues.

Where is Microsoft office Diagnostics?

Start => all programs => Microsoft Office => Microsoft Office tools => Microsoft Office Diagnostics

If at all we have office 2010. We may have to run the Repair available under control panel.

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

Product Applies To:

-SharePoint Server 2010

-SharePoint Foundation 2010