27 July, 2011

edit in datasheet is missing in sharepoint

I have a simple list which allows users to enter their timesheet for work they've done. The site administrator has reported to me that he is unable to see the "edit in datasheet view" menu option. I'm also no longer able to see the menu option either.

Troubleshooting Done:
1. Office Repair: If are any office issues then we can run the office diagnostics and check any corruptions are there or not.
2. manually unregister and register the owssupp.dll with regsvr32 (FYI:Path:-Office 12 folder)
3. we need to track that this issue is machine specific/user specific.
4. which kind of browser is used by that machine where the problem resides. troubleshooting purpose:we can check the behaviour in chrome/Firefox.
5. If its a problem with all the users then Central Administration is the only option by which we can fixed this issue.


Resolution:If the property is missing for everyone then the most likly problem is that ‘client integration’ is turned off.

Exact steps:
1. Go to Central Administration
2. Application Management
3. Authentication Providers
4. Select the secpific zone
5. Client Integration
6. Select Yes
7. Save

Once the Enable Client Integration option is enabled you will see those options for integrating with client application options on Sharepoint lists.

Note: If you are using Internet Explorer 8.0 (IE 8.0) then its altogther an different issue becuase of following reason:
Missing menu items in SharePoint can be caused by IE8 working in Standards Mode, instead of Quirks Mode, depending on whether or not there is a DocType available to make a mode available. But several hotfixes are available for different types of missing menu items.

If you have any queries/questions regarding the above mentioned information then please let me know..
I would be more than HAPPY to HELP U as well as RESOLVES UR ISSUES

3 comments:

  1. I found this problem does not appear when one doesn't use the 64 bits version of Internet Explorer 9.. When using the 32 bits version, all options are available..

    I have seen more issues when using the 64 bits version of IE 9, like in custom lists of Sharepoint some features are unreadable.. I wonder whether MS actually knows about this

    ReplyDelete
    Replies
    1. Thank you for sharing this valuable info! Yes, its true that 64-bit version has so many problems. But, please continue to share so that it will be helpful for others as well.

      Delete
  2. At the end of your article in the resource box place your affiliate link so the
    reader will click it once they finish reading. Like I
    said earlier, there are many ways that one can go about
    doing this. Selling info products such as digital ebooks from Click - Bank is a good way
    to solve people's problems and get paid for it.


    Also visit my weblog; legitimate ways to make money online

    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.