13 August, 2013

SharePoint 2010 Service Pack 2 Released

Access 2010 Runtime SP2
Duet Enterprise for Microsoft SharePoint and SAP SP2

FAST Search Server 2010 for SharePoint SP2

Groove Server 2010 SP2

Office 2010 Filter Pack SP2
Office 2010 Language Pack SP2
Office 2010 SP2
Office Language Interface Pack 2010 SP2

Office Proofing Tools 2010 SP2
Office Web Apps 2010 SP2

PowerPoint Viewer SP2

Project 2010 SP2
Project Server 2010 SP2

Search Server 2010 SP2

Server Language Pack SP2

SharePoint 2010 Indexing Connector for Documentum SP2

SharePoint Designer 2010 SP2
SharePoint Foundation 2010 Client Object Model Redistributable SP2
SharePoint Foundation 2010 Language Pack SP2

SharePoint Foundation 2010 SP2

SharePoint Server 2010 SP2

SharePoint and Project Server 2010 SP2

Visio 2010 SP2
Visio Viewer 2010 SP2

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.

12 August, 2013

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