06 February, 2011

The List cannot be displayed in Datasheet view


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.

19 comments:

  1. Great article, worked perfectly for me.
    Thanks!! :)

    ReplyDelete
  2. Yup, It helped me through some issues I had at the office. I love it how Amol takes his time to help us around with no profit intentions. This is wonderful, I will sure try and spread this blog around.

    ReplyDelete
  3. Yup, It helped me through some issues I had at the office. I love it how Amol takes his time to help us around with no profit intentions. This is wonderful, I will sure try and spread this blog around.

    ReplyDelete
  4. Thank you very much for your appreciation. Its my pleasure that my blog information helps you to resolves the issues that you were facing...Thanks again

    ReplyDelete
  5. Thank you for this solution. It works perfectly.
    related to this issue, I have another thing to ask. I am using IE9 and sometimes this 'Datasheet view' works, sometimes it doesn't. what could possibly cause this situation? thanks for the information

    ReplyDelete
  6. If you are running Internet Explorer 9 (32 and 64-bit are installed at the same time) use the 32-bit version. SharePoint doesn’t like using datasheet view if you are running IE9 on a machine with Office 64 installed so I will recommend installing MicroSoft Office Access Database Engine 2007 (haven’t tried 2010) found here:

    2007: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

    2010: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d

    ReplyDelete
  7. I have the reverse issue..I have list which is exported from Access. I want this list to be opened in Standard View and not in Access view by default. How do i set that up.

    Thanks

    ReplyDelete
  8. - Open the list in access
    - Copy the complete structure and paste it in Excel
    - Save that excel in .XLSX format to your desktop

    Now-

    - Open your sharepoint site
    - View all site content
    - Create
    - Import a spreadsheet
    - Browse the desktop location
    - select the excel spreadsheet
    - it will ask you to select the number of cells
    - select it appropriatly (its very easy)
    - Click OK

    The excel will be by default set in standerd view.. thats it :)

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

    ReplyDelete
  9. Hello Amol,

    I have a calculated field in my List and the formula is something like this
    =CONCATENATE("("","PSR","")
    This formula allows me to open a pdf file for each of the project from the list. A folder called PSR is available and all the pdfs are stored in that folder with the project id as the file name. This works fine..but
    I want to know if i can change the color of the font which says PSR in the List if the project file is not available that way i can identify from the color the number of projects where i have not received the PSR file.

    Thanks

    ReplyDelete
  10. It might be possible by using sharepoint object model i.e. purely customized coding but not possibe either by SPD as well as default OOB functionalities.

    ReplyDelete
  11. I was not able to get the datasheet view to display so I installed the updates above plus the update for Access. This allowed me to launch the datasheet view but then I get an error when I try to add or change a record.

    Cannot connect to the server at this time. Thoughts?

    ReplyDelete
    Replies
    1. please check this and let me know, Thank you

      1. Open the Internet Explorer
      2. Tools
      3. Internet Options
      4. Advanced Settings
      5. Scroll downwards and reach towards the section named as "Security"
      6. CHECK FOR SERVER CERTIFICATE REVOCATION--which is by default checked
      7. Unchecked it
      8. Apply and Ok
      9. Close all the internet explorers (IE) and open your SharePoint site in a new IE i.e. Browser/Explorer

      Delete
  12. Keep posting these blogs, good work

    ReplyDelete
  13. Apparently in my case, I was in IE 11, because of which data sheet did not work. Removed the IE 11 update and reverted back to IE 10, and it worked!

    ReplyDelete
    Replies
    1. Wonderful, Thanks Jayalakshmi for the update!

      Delete
  14. I have windows 7 (64 bit) and 64-bit Office 2013 installed. IE8 (as required by my company).Cannot get datasheet mode to work. I've tried all the activex settings to no avail, and cannot find any other updates or patches that I'm obviously missing. I have the same problem whether I use 32 or 64 bit IE8. Any ideas?

    ReplyDelete
    Replies
    1. Go for 32-bit office and your issue will be resolved! Please keep us posted, Thank you.

      Delete
  15. I am using IE 11 and getting the same error when try to see the Datasheet view in my sharepoint site "The Standard View of your list is being displayed because your browser does not support running ActiveX controls."

    ReplyDelete

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge

Note: Only a member of this blog may post a comment.