SharePoint
Lists are very useful in so many ways as it has the functionality of copy and
paste.
We
can use the SharePoint List in 2 ways:
1.
Graphical User Interface (GUI)/ Standard View
2.
Excel Spread sheet view /Datasheet View
Excel
Spread sheet view is very powerful as we can easily transfer the data from your
machine to SharePoint list by simply using copy and paste.
When
we tried to switch from standard view to datasheet view then most of the users
face the following error message:
The List cannot be displayed in Datasheet view for one or more of
the following reasons:
-A datasheet component compatible with windows SharePoint services
is not installed.
-Your Web browser does not support ActiveX controls
-Support for ActiveX controls is disabled.
Note:
I have seen that most of the users face this kind of issue if they are using
Internet Explorer 6.0 (IE 6).
Please
follow the below mentioned steps to resolve the issue:
Resolution
Steps:
1. Windows SharePoint Service Support options for Microsoft Office
should be installed (applicable for Office 2003 as well as for Office 2007)
How to enable this option:
A. Start-Control
Panel-Add or Remove Programs-click on Microsoft Office and then Change
B. Add/Remove Features
C. Expand the Office
Tools category.
D. Next verify that
you have both the Microsoft Office Access Web Datasheet Component and the
Windows SharePoint Services Support component installed.
E. If these components
are not installed choose to run them from your computer and then click the
Continue button and go through the installation process. You may need your
Office 2007 install media.
2. Next you want to verify that you can run ActiveX controls in
Internet Explorer. To do this open IE and go to the Tools menu > Internet
options
3. Next click on the Security tab and for your Trusted sites click
(choose Internet if you do not add your SharePoint sites to your Trusted Sites)
on the Custom level button
4. Verify that you can use previously unused ActiveX controls.
5. Verify that you can download signed ActiveX controls and that
you can run ActiveX controls and plug-ins.
6. The next setting is –> select "Enable" for Script
ActiveX controls marked safe for scripting.
7. Adjust these settings accordingly and then click OK twice to
return to Internet Explorer.
8. You may need to close Internet Explorer and re-open the program
before your new settings take hold and become active.
If
you have any queries/questions regarding the above mentioned information then
please let me know, Thank you.
