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


Post New Web Links

Datasheet view is always read-only

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

I have a list on a site.  The list has a few fields from the BDC, but the rest are either numeric or choice lists.

 

I created a datasheet view on it, and I can edit the items in the list.

 

But once I enable content approval on the list, the web part showing the list in datasheet mode becomes read-only for all fields.

 

If content approval is enabled, is there any way to use a datasheet view in a web part and allow the user to edit the data?  (if the answer is no, why not!)

 




View Complete Post


More Related Resource Links

Read Only Managed Metadata column in DataSheet View

  

i am unable to edit managed metadata columns in the DataSheetView, i have other columns which are number, text field type which i am able to edit. So the view is not readonly, it is only when i click cell with the managed metadata column i get the readyonly prompt.

Evironment : Sharepoint 2010, Office 2007 and a pissed off customer

Appreciate any help


I am what i am

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?

SharePoint 2010 datasheet view 64 bit vs 32 bit

  
I think that the Windows 7 64 bit I have is causing problems between My Office Suite (32 bit) and my IE 8 is (64 bit). I am not able to edit in datasheet view and my upload multiple documents is greyed out? Any help would be greatly appreciated! Thanks!

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  

Read only view to certain columns in a list

  
Hi, I am using SP 2010 and needed help in customizing an exisiting list. I need to make 3 columns of the list editable to 3 users only and the rest of the users have a READ-ONLY option. How can this be done?

Update Datasheet View with Blackberry?

  
Has anyone seen a Blackberry update a SharePoint List in Datasheet View? I know I can update a SharePoint list in Standard View, but need to be able to update in datasheet view.

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

How to apply dynamic filter in Datasheet View from Query String

  
The datasheet view doesn't support either connections/dynamic filters from Query string. How to filter the data using query string?

WSS and MOSS Datasheet view people and groups bug or limitation

  
I need help trying to work around a limitation with the datasheet view with a list in sharepoint WSS and MOSS.  I need to figure out how to fix the people and group lookup fields so it will not corrupt my data. Currently  the data filters for this type of group does not work.  I have listed the steps below on how to recreate my issue:1. Create a sharepoint group called DELETEMETEST  > add a user to that group2. Create a new list3. Create a column in the list called DELETEMEPEOPLE > Select people only > Choose From DELETEMETEST Group4. Finish creating the list5. Create item in the list    * Notice that if you search for users in DELETEMEPEOPLE it will only show the users assigned to the group.6. Finish creating the record.Back at the listActions > Edit in DatasheetNotice that the DELETEMEPEOPLE now no longer has any filters, and you can add people outside of the DELETEMETEST Group.What are the possible solutions to working around this issue?1. Setting a bit flag on the SPField - Didn't see one that only worked for the datasheet.    2. You could make a custom field type of people and groups and that would make it read only in the datasheet, but isn't that a lot of work for something that is already created?Thanks for any advice....Ivan

Edit in Datasheet view does not work on one SharePoint 2007 farm, works on another.

  
The ability to edit in datasheet view on one of our environments no longer works.  I've tried different client machines on different builds and regardless of the install every library, list, etc. when attempting to edit in datasheet view shows as read only.  Our other environments those systems work as intended with those same clients. I've searched all over and haven't found anything that helped.  Any ideas?

How to put Data in multi Taxonomy type fields using Datasheet view

  
Hi, We have a requirement where data has to be uploaded to a list having a Multi Taxonomy column.Is it possible to do so using datasheet view. Or please suggest if there is any other way. Thanks, Ash

data view web part - read and write using web service

  
Hi I am looking for an example on "Data View Web Part" in WSS 2010 to read and write data from a web service that I have written and then update the database. or if you have a any better way of doing this function of reading and writing data to and from "Data View Web Part" in WSS 2010. Thanks heapes in advance. Kind Regards,  sword

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.      

"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

Columns in Doc Library Standard View are not seen in Datasheet View

  

All the columns appearing in the Standard view of my doc library are not appearing in the Datasheet view. I've look through all the information I have and it all it appears to indicate that boht views sould match:

Office and SharePoint 2007 User's Guide, by Michael. Antonovich published by Apress-
" . .this view displays the same information as the Standard view."

SharePoint 2007 by Ishai Sagi, published by SAMS- "The Datasheet view displays all the columns that were on the standard view."

In the Standard view these columns appear: Type,Name, Checked Out To, Check-In Comments, Modified, Modified By and Version.

Yet in the Datasheet view of the same library these columns appear: Type,Name, Checked Out To, Modified,and Modified . The Check In Comments is missing and the Version column are missing.

I don't see this same problem with lists imported from a spreadsheet.  In those instances the Standard View and the Datasheet view are an exact match.

Any ideas?
Thanks so much!
Laura

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