Tuesday, August 13, 2013


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

SharePoint 2010: Change Regional settings in Central administration as well as at the site collection level

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.

Monday, August 12, 2013

Cannot import Spreadsheet 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

Sunday, August 11, 2013

Lookup column from Sharepoint list returns limited values in Word.


Document information panel (aka Ribbon) in word only lookup 30 items from SharePoint list which have around 500 items.


Document Information Panel (aka the Ribbon) uses the default view list of a lookup column to determine how many items to show in a dropdown list
Parameter Item Limit in view settings need to be adjusted according to the number of items present in column of the list as shown below.

Error : Problem occurred while contacting to the server. If the problem continues, contact your administrator while editing office documents in SharePoint 2010


Not able to edit office documents on SharePoint site and facing below error
Problem occurred while contacting to the server. If the problem continues, contact your administrator.


 It is not uncommon for the web folders / WebDAV support in Windows XP to just stop working for no apparent reason.
You can usually reinstall the original Web Folders support by finding and executing webfldrs.msi with specific options.
Webfldrs.msi is probably in one of your system directories. It is easiest to search for it (remember to set advanced search options to include system and hidden folders). When you find the program (it’s a normal Microsoft install package) launch it, then do these steps:
  • Click “Select Reinstall Mode”
  • Uncheck “Repair all detected reinstall problems”.
  • Check “Force all files to be reinstalled, regardless of checksum or version”.
  • Check “Verify that required user registry entries are present”.
  • Check “Verify that required machine registry entries are present”.
  • Check “Validate shortcuts”.
  • Press OK
  • Normally no reboot is required.
  • Now the web folder client should have been restored as it was shipped.


snow flakes

blogger widgets Blogspot Tutorial


Related Posts Plugin for WordPress, Blogger...