Showing posts with label edit in datasheet is missing in sharepoint; Lists Missing "Edit in Datasheet" option;SharePoint List – “Edit in Datasheet” issue. Show all posts
Showing posts with label edit in datasheet is missing in sharepoint; Lists Missing "Edit in Datasheet" option;SharePoint List – “Edit in Datasheet” issue. Show all posts

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