You cannot use SharePoint. Your System Administrator has turned off that feature

One of my user was trying to use the outlook integration feature of sharepoint(action-connect to outlook). Everybody knows that we use this feature to connect our list's and libraries to open in outlook. See over here, we need to understand that this is not a problem of sharepoint but its a design behaviour of outlook 2007. Why this is a design behaviour if it works perfectly fine with Outlook 2003 ?

The answer to your question is this post which is written by Jose Barreto:
http://blogs.technet.com/b/josebda/archive/2007/01/27/enabling-and-disabling-sharepoint-integration-in-outlook-2007.aspx

For outlook 2003, Microsoft has already published an article which is an awesome one: http://support.microsoft.com/kb/831057

Jose Barreto clearly explains that Office 2007 setup carried that setting from the old 2003 location and that's why it was there in the first place, even though nobody (but Office 2007 Setup and Outlook 2007) knew the new location.

I hope the above mentioned information is pretty much clear to understand as well as resolves your issue. Please let me know in case of any queries/issues/questions. I would be more than happy to help you as well as resolves your issues, thank you J

Edit in Datasheet View in Sharepoint without MS Office installed

Why you cannot view a list in Datasheet view on a Windows SharePoint Services Web site ? I know everybody knows the answers:

This behavior occurs if one or more if the following conditions are true:
•A datasheet component that is compatible with Windows SharePoint Services is not installed.
•A Microsoft Office Professional edition is not installed on the computer. •The Web browser does not support ActiveX controls.
•Support for ActiveX controls is disabled.

Edit in datasheet gives you the way by which you can perform bulk updates and deletes. But the problem or you call it as necessity that Office package should be insatalled on your machine.

but what if-you dont have a office installed on your machine and you need to do some important work. Dont worry-Here is the solution:
You just have to install the AccessDatabaseEngine from Microsoft and it will give you the edit in datasheet mode.

You can download the database engine from the following location:http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en

I hope the above mentioned information will be usefull to you as well as resolves the issue when requirement arises. Please let me know in case of any issues/queries/questions.
I would be more than happy to help you as well as resolves your issues, Thank you

Reference:http://office.microsoft.com/en-us/sharepoint-server-help/use-datasheet-view-in-64-bit-office-2010-HA101882420.aspx

http://msdn.microsoft.com/en-us/library/ee691831.aspx

http://support.microsoft.com/kb/2266203

SharePoint Column/View Permission

As we all aware that there is no out of box way in sharepoint by which we can achieve column level permissions. but would like to highlight one third party utility which will be very effective and fullfill all the requirements.

You can get this utility here : SharePointBoost

What are the benefits:
----------------------------
1. SharePoint administrators can now assign to Users and User Groups all relative permissions at Columns-and Views-level.
2. Permissions can even be defined using conditions, so that the values of certain fields determine permissions dynamically.
3. Permissions settings can be imported or exported as XML file for easy management and batch permissions assignment. 

SharePoint Column/View Permission provides further protection on list columns and views than the SharePoint permission system does. Using it, you can safeguard the confidential column contents from access and edition by unauthorized users.

Main highlights:
-------------------
1. Hide or read-only columns in a list
2. Hide or read-only views in a list
3. Set Permissions According to Conditions
4. Hide columns in Alert Me email
5. Add Extral Protection against Access from Web Services

I hope the above mentioned information is pretty much clear regarding the SharePoint column permisisons utility.http://www.sharepointboost.com/columnpermission.html

The List Cannot be Displayed in Datasheet view.....

Display a list in Datasheet view. Datasheet view requires that you have a Windows SharePoint Services-compatible datasheet program installed, such as Microsoft Office 2010 Professional. Datasheet view lets you add, delete, and update list entries just as you would in a spreadsheet program, such as Microsoft Office Excel 2010. Come across such issue that belongs to datasheet view and details are as follows:

As we all know that SharePoint list consist of two views by default: Standard view and datasheet view. The standerd view is working fine without any issues but when i changed the view from standerd view to datasheet view then i faced the below mentioned problem | error message:

The list cannot be displayed in Datasheet view for one or more of the following reasons:
•A datasheet component compatible with Microsoft SharePoint Foundation is not installed.
•Your Web browser does not support ActiveX controls.
•A component is not properly configured for 32-bit or 64-bit support.

Configuration:-
-Machine OS: Windows 7 (64 bit)
-Office installed: Office 2010 (64 bit)
-IE version: IE8.0

Resolution:
Issue has been resolved because of this post

You can solve the issue by installing the “2007 Office System Driver: Data Connectivity Components” downloadable under:http://www.microsoft.com/download/en/confirmation.aspx?displaylang=en&id=23734

Why this issue occurs:
The ActiveX control for the Datasheet view is not compatible with Office 64-bit versions.

what is imporant to note:
Microsoft strongly recommends the use of 32-bit (x86) versions of Office 2010, Project 2010, and Visio 2010 applications as the default option for all platforms.
Office 2010 64 bits will not be required in most of the scenarios.

Note: DataSheet is an ActiveX control so it would work with only Internet Explorer.

I hope the above mentioned information is pretty much clear to resolve the issue but still in case of any doubts/queries/questions then please let me know.
I would be more than happy to help you as well as resolves your issues, Thank you

Sharepoint list columns not visible in datasheet view

Display a list in Datasheet view. Datasheet view requires that you have a Windows SharePoint Services-compatible datasheet program installed, such as Microsoft Office 2003 Professional. Datasheet view lets you add, delete, and update list entries just as you would in a spreadsheet program, such as Microsoft Office Excel 2003. Come across such issue that belongs to datasheet view and details are as follows:

ISSUE:

Some list columns are not visible in datasheet view

CAUSE:

This issue can be observed only if following is true:

1. Office 2003 is the primary office package installed at user workstation

2. List contains columns in which multiple values are allowed.

Multi-valued columns are not visible in datasheet view if you have office 2003 installed.

This is a by-design behavior.

RESOLUTION:

Any of the following is applicable to resolve this issue:

1. A feature needs to be installed called "Microsoft Office Access Web Datasheet Component". This feature can be found in the installation UI as a sub-feature of "Windows SharePoint Services Support".

2. Install “Access Runtime” which can be found http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=4438

3. Upgrade office package to version 2007

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

References:

SharePoint Datasheet View and Office 2010 64-bit

http://www.knowsharepoint.com/2010/06/sharepoint-datasheet-view-and-office.html

SharePoint: ActiveX Error When Trying to View List in Datasheet View: http://weblogs.asp.net/felipeferreira/archive/2009/07/30/sharepoint-activex-error-when-trying-to-view-list-in-datasheet-view.aspx

Cannot edit lists in Datasheet view

http://objectmix.com/sharepoint/329100-cannot-edit-lists-datasheet-view.html

 SharePoint 2007: Use the Datasheet View to Add, Edit, or Delete Items and Files: http://programming4.us/enterprise/2402.aspx

How to Create Folders in a SharePoint Wiki Library?

As I mentioned in my last post that Wiki libraries are completely different and special ways are mentioned to achieve some functionality. So requirements will be many, library configurations will be different, library parameters will change but we need to move in that direction to achieve that functionality. It might be possible that it is resolve by using out of box functionality or by using SharePoint object model i.e. complete customization's. Don’t worry guys-we will concentrate only on out of box functionality to achieve these requirements.


Let’s go ahead and resolve this request:
Wiki libraries are configured in such a way in which you will not find an option to create a new folder.


Solution is very simple-
1.By default the view that you can see in the wiki page library is “All Pages”
2.Change the view from ‘All pages’ to ‘Explorer view’
3.When you will change the view then you will see an alone folder named as ‘Forms’. This is part of explorer view so please don’t delete it and keep it as it is.
4.Now this is windows network view and you can use all windows operations here so please go ahead-Right Click and you will get the option of ‘NEW FOLDER’
5.Assign appropriate name to a folder as per your project requirements
6.Now change the view from ‘Explorer view’ to ‘All pages’
7.That’s it-folder will be successfully created inside a wiki page library.


Easy! Simple! Neat & Clean-Mission accomplished and request completed.
If you have any queries/doubts 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

Moving Wiki Pages Between Wiki Libraries in Sharepoint 2007

SharePoint has three primary page content-types: Wiki pages, Web-part pages, and Publishing Pages. Unlike prior versions of SharePoint, the default page type is a 'Wiki Page', which enables free-form editing based on the ribbon toolbar. It is possible to insert Web-parts into any page type. In this article, we will explore some insights related to Wiki.

Wikis are a useful living repository of information, allowing a build-up of shared knowledge in an easily managed and accessed format. But suppose if you want to transfer this wiki pages to another document library within the same site collection/different subsite within the same site.

Requirement: Transfer wiki pages from one place to another within same site collection.

Wiki library has its own existence and not like normal document libraries. For normal document libraries, we can easily transfer the documents by saving the library as template/using the explorer views of both libraries. But this not applicable for the Wiki libraries as they are little bit different configurations.

Let’s go ahead and achieve these requirements:

To explain this-I am keeping two document libraries named as Library A and Library B.

Both are wiki libraries. I wants to transfer the wiki pages from library A to library B.

Both the libraries are located on the same site collection i.e. root site but scenario will be: One library is at root site and another library is at subsite.

1.Go to the site where library A resides. 

2.Site actions

3.Site settings

4.Under site administration

5.Site content and structure

6.You will see two partitions now left navigation and right navigation

7.Select the library i.e. library A. As soon as you click on it then it will show the underneath pages in the right navigation pane

8.Now pages are in front of you, by default maximum 100 pages will be present on a single page, so if your library contains more than 100 pages then change the number from the right hand side.

9.Now select all the pages by clicking ‘select all’ check box

10.Actions

11.COPY

Note: You will see three options under actions-Copy, Move and Delete. Why I have selected COPY because it will keep the pages in both the libraries and we can cross check when the transfer operation will complete by comparing the numbers under view all site content.

If you select ‘MOVE’ then pages will be completely moved from library A and transfer to library B. it means that library A will be empty now and you don’t have any chance to rectify if the transfer operation fails.

When you will select COPY then you just have to wait for few seconds and it will give you a choice to select the destination library under any site that exists under the same site collection.As soon as you will select the destination library and click OK then operation will starts and will take some time depending upon the number of pages to be moved.

Note: Please don’t refresh or click anywhere when the operation is in progress, if you do such activity then pages won’t be moved and transfer operation fails.

I hope the above mentioned steps are pretty much clear to achieve the requirements as mentioned above. In case of any queries/questions then please let me know.

I would be more than happy to help you as well as resolves your issues, thank you.

Document Library Basics-SharePoint 2010

In this session, we will try to concentrate on ‘How To’ things associated with the documents as well as with the document library in SharePoint 2010 that includes the following things:

1.   How to change the document name

2.   How to check out the document

3.   How to download a document

4.   How to send the document library link

5.   How to manage permissions on a single document

6.   How to create a folder in document library

7.   How to delete the document

8.   How to create a view in document library

9.   How to set an alert on document library

10. How to set permissions on document library

Let’s start one by one:

How to change the document name

1.   Open the document library in which that document resides

2.   Select the check box of that document

3.   From the top ribbon, select Edit document (please refer the below mentioned screenshot)

4.   Or Hover your mouse to that document and you will get the dropdown like this:



Note: All document related activities are associated with ‘Documents’ section which is present under Library Tools

How to check out the document

1.   Open the document library in which that document resides

2.   Select the check box of that document

3.   From the top ribbon, select check out

4.   Or Hover your mouse to that document and your will get a dropdown like this:



How to download a document

1.   Open the document library in which that document resides

2.   Select the check box of that document

3.   From the top ribbonàDownload a copy (please refer the below mentioned screenshot)

4.   Or Hover your mouse to that document and you will get the dropdown like this:



How to send the document library link

1.   Open the document library in which that document resides

2.   Select the check box of that document

3.   From the top ribbon, select Email a Link(please refer the below mentioned screenshot)

1.   Or Hover your mouse to that document and you will get the dropdown like this:

How to manage permissions on a single document

1.   Open the document library in which that document resides

2.   Select the check box of that document

3.   From the top ribbon, Select Document permissions

4.   Or Hover your mouse to that document and you will get the dropdown like this:

How to create a folder in document library

1.   Click on the document library in which you wants to create a folder

2.   From the top ribbon, select NEW FOLDER (Under documents section) [Pease refer the below mentioned screenshot)

How to delete the document

1.   Open the document library in which that document resides

2.   Select the check box of that documents that you wants to delete

3.   From the top ribbon, select DELETE DOCUMENT(please refer the below mentioned screenshot)

4.   Or Hover your mouse to that document and you will get the dropdown like this:

How to create a view in document library

1.   Open the document library in which you wants to create a view

2.   As view is a part of LIBRARY and not a document so that’s why we will select the section of library from the top ribbon(please refer the below mentioned screenshot)

3.   Select the option that’s says-CREATE VIEW

How to set an alert on document library

1.   Open the document library on which you wants to set an alert

2.   Under Library ToolsàLibrary section

3.   Select Alert Me (Please refer the below mentioned screenshot)

How to set permissions on document library

1.   Open the document library on which you wants to set up permissions

2.   Under Library toolsàLibrary section

3.   Library Permissions(please refer the below mentioned screenshot)

4.   Or Library settings

5.   Under permissions and management

6.   Permissions for this document library

If you have any questions/queries regarding the above mentioned information then

please let me Know. I would be more than happy J to help you as well as resolves

your issues, Thank you

References:

1.   Create, Delete or Modify View: http://office.microsoft.com/en-us/sharepoint-server-help/create-modify-or-delete-a-view-HA010377693.aspx

2.   How to manage permissions for a list, library, folder: http://support.sherweb.com/Faqs/Show/how-to-manage-permissions-for-a-list-library-folder-or-document-item-sharepoint-2010

3.   User permissions and permission levels: http://technet.microsoft.com/en-us/library/cc288074.aspx

4.   Delete a document: http://office.microsoft.com/en-us/windows-sharepoint-services-help/delete-a-library-HA010223998.aspx

5.   Managing alerts: http://office.microsoft.com/en-us/windows-sharepoint-services-help/about-managing-alerts-HA001161282.aspx

How to transfer the document library from one site collection to another site in SharePoint 2010

We always transfer the documents from one document library to another but it would be great if I can transfer the complete library from one place to another.

Conditions will be:

1.   Movement of document library from parent site to subsite

2.   Movement of document library from one site collection to another

3.   To make the replica of one document library and create another one by means of archiving purposes

This information will be basic but very vital for the beginners who have started learning sharepoint from the ground level and document library will be undoubtedly important from business perspectives as we use it on daily basis.

So let’s start how we will achieve this requirement:

1.   Open the document library that you wants to transfer from one place to another

2.   Under library toolsàselect Library

3.   Library settings (please refer the mentioned screenshot)

4.   Under permissions and management

5.   Save Document Library as Template

When you will do this then it will ask to provide File name and Template name, make sure to select the check box that specifies “Include Content” and click OK

6.   The above action will save the library under list template gallery (/_catalogs/lt/Forms/AllItems.aspx)

7.   Now go to the list template gallery

8.   Click on the file name that you have provided and it will ask you save the template to your desktop

Now depending upon the project requirement, you can use this template anywhere.

Suppose if you want to create a same library under subsite then you can create now you can get this file under View all site contentàCreate

Suppose if you wants move this library to another site collection then simply upload the template file (that we have saved to desktop) to the list template gallery of another site collection (this is the site collection where you wants the library to move/Designate)

Here are the detailed steps in case of any confusion:

1. Lets go source SharePoint site collection
2. Site Actions
3. Site Settings
4. Galleries
5. List Templates
6. Click on the file name that you have provided and it will ask you save the template to your desktop
7. Now switch to Destination SharePoint site collection
8. Site actions
9. Site settings
10.  Galleries
11.  List Templates
12.  simply upload the template file (that we have saved to desktop) to this list template gallery

 That’s it-Now you will find this uploaded template under library creation path i.e. site actionsà View all site contentàCreate

I hope the above mentioned information is pretty much neat and clear but still please don’t hesitate if you have any queries/questions

I would be more than happyJ to help you as well as resolves your issuesJ

References:

1. http://pravahaminfo.blogspot.com/2011/05/how-to-move-document-library-from-one.html
2. http://weblogs.asp.net/bsimser/archive/2010/08/26/sharepoint-document-libraries-and-horrors-oh-my.aspx
3. http://technet.microsoft.com/en-us/library/cc262215.aspx

   4.http://social.msdn.microsoft.com/Forums/en/sharepoint2010general/thread/67282348-25c7-4bd0-9d95-61024c6892f9

How to create a document library in SharePoint Server 2010?

1.     Open your SharePoint site

2.     Select “Site Actions” from the left hand side top corner(refer below mentioned screenshot)

 

3.     Select View all site contentàCreate

4.     As soon as you will click create then it will redirect to page where all types of list’s and libraries options are available

5.     Select the appropriate document library as per your project requirement

6.     Enter the title and URL name

7.     Click createàthat’s it, document library will be successfully created.

If you wants to check the more options then it will Permissions, Navigation and Navigation inheritance (please refer the below mentioned screenshot)

Microsoft has published an awesome document on this:

http://technet.microsoft.com/en-us/library/cc262215.aspx

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

References:

1.     www.youtube.com/watch?v=Oa8xB-jbZo8

2.     http://www.hosting.com/support/sharepoint3/createdoclib

3.     Introducing Document Management in SharePoint 2010:http://blogs.msdn.com/b/ecm/archive/2010/02/15/introducing-document-management-in-sharepoint-2010.aspx

4.     Assembling Documents on SharePoint 2010 Sites by Merging Content from Excel, PowerPoint, and Word: http://msdn.microsoft.com/en-us/library/ff519529.aspx

5.     SharePoint Document Libraries and Horrors: http://weblogs.asp.net/bsimser/archive/2010/08/26/sharepoint-document-libraries-and-horrors-oh-my.aspx

An error has occurred. Please contact your system administrator if this problem persists.

While working with a user yesterday, i have noticed that users could not view Excel files in browser and getting the below mentioned error message:

Error Message:

An error has occurred.

Please contact your system administrator if this problem persists. 

ULS Logs shows the following entry:

There was an error in communicating with Excel Calculation Services http://sharepoint:28963/SPAdmin/ExcelCalculationServer/ExcelService.asmx exception: The request failed with HTTP status 401: Unauthorized.

Checked the event viewer and found the following:

Event Viewer entries:

Event Type:        Error

Event Source:    Office SharePoint Server

Event Category: Excel Services Web Front End

Event ID:  5234

Date: 12/7/2012

Time: 2:50:06 PM

User: N/A

Computer: XXX

Description:

No Excel Calculation Services is available in the farm.[User:

SHAREPOINT\system]

Event Type:        Error

Event Source:    Office SharePoint Server

Event Category:  Excel Services Web Front End

Event ID: 5239

Date: 12/7/2012

Time: 2:50:06 PM

User:                     N/A

Computer: XXX

Description:

There was an error in communicating with Excel Calculation Services

http://sharepoint:28963/SPAdmin/ExcelCalculationServer/ExcelService.asmx

exception: Unable to connect to the remote server

[Session: (null)

User: SHAREPOINT\system].

Troubleshooting Done:

1-checked this article: http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/8bba2694-7276-4505-85a5-02f91b92bb1d  which states that find the ssp which is giving the problem and recycle the app pool to which the ssp is referrencing.

2-http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/321cb536-39d6-4ee9-b9ef-65db9e133d97but cannot apply this resolution as in my case the excel services are running fine for other portals and not working for only one web application.

3-http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/5968cb82-2e65-44c0-bfa8-ce05d70154ff this article has mentioned 3 fixes which will varies from the farm to farm i.e. enviornment to enviornment.

4-Checked alternate access mappings as per this article:http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/c0c59a6a-1cf6-4280-a2ca-9667b2cadd33/ but AAM seetings are fine in our enviornment.

5-Ran this below mentioned commands but no results:

stsadm -o setsharedwebserviceauthn -negotiate

stsadm -o execadmsvcjobs

6-checked SSP pool account is running or not as per this article: http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/85310dd3-a7e7-4673-b258-b0fec7823b8d  but it is fine and no problems

7-excel services are running or not is already checked: http://njbblog.blogspot.com/2008/04/sharepoint-v3-error-excel-services.html

Resolution that fix our issue:

If you get this problem the solution in my case was to by pass the proxy for local requests, this was done by editting the web.config for the relevant web app & adding:

<system.net>

<defaultProxy>

<proxy proxyaddress="http://<ProxyServer>:<port>" bypassonlocal = "true"/>

</defaultProxy>

</system.net>

------------------------------------------

what we have added in this: bypassonlocal = "true"

Issue has been resolved and excel services started working without any issues, Thank you

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, Thanks