.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Bulk editing issue - list cannot be displayed in Datasheet view

Posted By:      Posted Date: October 20, 2010    Points: 0   Category :SharePoint
 
 

 

On a sharepoint page i click on 'Actions' tab then select 'Edit in Datasheet'  and i see 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 browser does not support ActiveX controls, or support for ActiveX controls is disabled. "

 

I am using XP professional, IE 6.02 to access the sharepoint site.

 

I was hoping that the hot fix KB938888 would fix that issue, but it did not. bulk editing is a nice feature that i would like to use but i have never been able to. The link to export data to Excel works fine.

 

if anyone has suggestions, thanks in advance

a23rd.




View Complete Post


More Related Resource Links

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

  
I created a standalone Win 2008 R2 x64 server,performed a Basic SharePoint Foundation (beta) install, installed Office 2010 on the same box, and am using IE 8 on that box to browse SharePoint sites. When I try to view a list in Datasheet view I get this error:The list cannot be displayed in DataSheet view for one or more of the following reasons:- A datasheet component compatible with Miicrosoft Sharepoint Foundation is not installed.- Your web browser does not suport ActiveX controls- A component is not propelry configured for 32- or 64-bit support.How can I troubleshoot this?TIA,barkingdog

The list is displayed in Standard view. It cannot be displayed in Datasheet view for one or more of

  

The list is displayed in Standard view. It 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 browser does not support ActiveX controls, or support for ActiveX controls is disabled.


Hey guys I have this showing up on my list that I can not see the Datasheet view. I have added sharepoint as a trusted site, enabled all my active x controls, I have update internet explorer 8, working on windows 7, and have installed office 7. I dont understand whats going on here. It works for the majority of our employees, but not all. Is there something I'm missing.

I've googled the ____ out of this and have seen this issue being talked about around 2007 but nothing recently so im guessing there is an answer out there that I havent found. Please help

Issue with People and Groups type of column in datasheet view of shrepoint list.

  
Hi,

We have a list created in MOSS 2007 which has a column of type people and groups. When we open the list in datasheet view and try to add records for people and groups type of column the column shows only records from All People section of the site collection. I have verified this for another site collection within the same web application where I am able to see all the users though they are not in the All people section of site collection.
Could anyone please let me know if I am missing any setting or if there is any change required to see all the user names in the people and groups type of column in datasheet view.

Thanks ,
Deepak

Datasheet view lookup column issue

  

When a column that has a lookup is empty in datasheet view and I attempt to update a different column I get this message: the text entered for isn't an item from the list. select an item from the list, or enter text that matches one of the listed items.

I found this hotfix, but it did not apply.

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

Any ideas how to get this resolved?


List view - inline editing with read only fields

  
I'm new to sharepoint and using SP2010. I would like to use the inline editing feature of list view and at the same time to lock some of the fields. Is there a simpler way to achieve this like adding some field property using SP designer?

Can Managed Metadata columns be edited in the DataSheet View of a Library or List?

  
Hi, I like to mass set document properties in a library using DataSheet View, the properties are columns based on Managed MetaData values. When I open the doc library in Datasheet view, those columns become read-only. I made sure the library does not require 'Check Out' and also tested it in other views then the AllItems view. Can someone confirm what is the expected functionality and or if there is a bug?

Can Managed Metadata columns be edited in the DataSheet View of a Library or List?

  
Hi, I like to mass set document properties in a library using DataSheet View, the properties are columns based on Managed MetaData values. When I open the doc library in Datasheet view, those columns are read-only. I made sure the library does not require 'Check Out' and also tested it in other views then the AllItems view. Can someone confirm what is the expected functionality and or if there is a bug? Should I be able to edit them in 2010 and were they editable in 2007 version. Please help. thanks. I came across this other post which suggests that functionality is not available ? pls someone confirm. Mass-editing metadata when documents are uploaded (individually or in bulk) to MOSS 2010  

Cannot display list in Datasheet view sharepoint 2010

  
Hello, I encounter the following errror when I want to display a list in datasheet view: The error messaqe says: A datasheet component compatible wiht Microsoft Sharepoint Foundation is not installed Your web browser doesnt support active x controls a component is not properly configured for 30-bit or 64-bit support. Does anyone know how to solve this problem? I am running windows 7 X64 + Office 2010 x64 Internet explorer: 8.0 Thanks a lot, Jacques

Edit in Datasheet View on List is not working

  
I have a list with simple column types like single line of text, Number, Hyperlink,  Picture, choice. When i edit the list in datasheet-view, below error is getting displayed. An unexpected error has occured. Changes to your data cannot be saved. For this error, you can retry or discard your changes. This error is occuring on edit certain rows/columns only. The view is having a simple filter condition. Could anyone check and suggest a solution/workaround for this ? Thanks in advance.      

# string with cross site lookup field value of List in datasheet view in moss 2007

  
I am getting appended # code value with cross site lookup field value of List in datasheet view, and also i am getting this value while export to Spreadsheet. How to remove this value.....

# string with cross site lookup field value of List in datasheet view in moss 2007

  

I am getting appended # code value with cross site lookup field value of List in datasheet view. I dont want that hash coded value, i need actual value. Please provide me the solution.

 

Thanks

Rajanikanth Rayala


Calendar List View Issue - No Month, Week, Day Icons

  

I'm trying to setup a Calendar view for a list in SharePoint 2010. Everything is working the way I want, except there are no icons to change the view from Month, Week, or Day. Right now, if someone clicks on a date on the calendar, it switches to the Day view. But there is no way for them to go back to the month view.

I open the page in SharePoint Designer, and in the Design view I can see three icons on the Calendar (Month, Week, Day). But at no time do these icons show up anywhere except the design view.

I want it to have the arrow buttons, the month and year (which are already displaying) and then the icons to change the view. How do I get them to appear?


Editing the list and view of a content query web part

  

I have added a content query to my site which is querying a master contact list.

Once I have added the web part I then want to customised how it is displayed, i.e. first name, company name etc.

I am not getting a list menu in the ribbon when I check the box next to my content query web part heading.

Can anyone help.


Using the DataSheet view on a linked list webpart page

  
I would like to link a master and details list via webpart connection, but show the details list not in the standard list view but rather in the DataSheet view. This would make data entry much more convenient. The idea is that the datasheet would filter by parent-ID (lookup field) and new records would automatically get the same parent-ID. I could not accomplish this without code, so I was wondering whether anyone in the VS section of the forum has attempted anything similar. Thanks for any guidance you can give....
Iko

Is there a way to use freeze panes in a SharePoint List's datasheet view?

  

I have created a custom list in MOSS 2007. I have inserted values for 3 columns which will be fixed and read-only. I want to freeze those 3 columns(like freeze pane in Excel). And other columns should be scrollable. Is it possible?



Gridview with a dropdown list for editing

  

Hello. I am working through Scott Mitchell's ASP.Net in 24 hours book. I am finishing the photo album project.

I have a GridView that retrieves a list of uploaded photo rows for the logged-in user.
The GridView is for editing and deleting rows.

The photo Category field in the Gridview is a dropdown list. The text entry field was deleted after converting this field to a Template.

Like the uploaded photos, these Categories are user-specific. They are created in another web page.

Users also have the option to select "none" for the category when they upload an image.

For the GridView:  The Category ID field's ItemTemplate and EditItemTemplate both have a " - None - " choice added to them.

I am getting this error:

'pictureReadOnlyCategories' has a SelectedValue which is invalid because it does not exist in the list of items. Parameter name: value

 

Note: The ID for the ItemTemplate for that dropdown list is the ID listed above in the error: "pictureReadOnlyCategories".

 

Am I missing some step in this process of changing a GridViews text field to a dropdown that can be used for editing? I went through the book's instructions three times.


Here is my code for the dropdown list and a screenshot of the Design

Security Briefs: Access Control List Editing in .NET

  

Access control lists (ACLs) can be complex beasts, and user interfaces for editing them are incredibly tricky to implement properly. That's why I was really excited when Windows® 2000 shipped with a programmable ACL editor, shown in Figure 1.

Keith Brown

MSDN Magazine March 2005


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend