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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Cannot edit datasheet in WSS 3.0. Getting Unresolved errors.

Posted By:      Posted Date: August 30, 2010    Points: 0   Category :SharePoint
I have two users who cannot edit in a datasheet view in SharePoint 3.0. I have tried reinstalling Office and IE. To no avail, this is becoming a big problem. All my other 40 users can edit just fine. I do not want to resort to reimaging the machines. I would rather fix the problem and document. Logged into the users machine, they cannot edit and when I login, I cannot edit. But if they log into my machine, they can edit. Any help would be appreciated.

View Complete Post

More Related Resource Links

Unable to edit in datasheet - WSS 3.0

When I try to edit a list in datasheet view I receive the following error: 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. This worked as of 2 or 3 weeks ago ( I do not remember the last time I tried it), and I cannot think of anything that has really changed locally or on the server. Other users have no issues. I have office 2003 with the SP parts installed. It is in my trusted site list and security is set to custom off a low template. All activeX controls are set to "allow" for the zone. I am also running IE 7 and SharePoint designer 2007, but both of these have been while it was working. Could a Windows or Office update have caused the problem? Any ideas?

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?

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.      

Not able to edit wiki page library in datasheet mode.


Hello ,

I created a wiki page library and when I change the mode to Actions----->Edit in data sheet,it opens in Data sheet view.

But I am not able to edit the data sheet.The data sheet is frozen.

Am I missing something? Is it possible to do that.





Unable to edit in Datasheet View


Myself and several other users try to edit cells in a datasheet view and often get the error:  "Edit control creation has failed. You cannot edit cells".  This is an intermittent problem. We are all running Windows7 and Office 2007. Any ideas what causes this?

problem while doing edit in datasheet view

this is regarding the sharepoint list. we have selected a sharepoint group for 1 of the column in a list. Those group peoples are displayed properly while editing in  standard view but when we try to edit in datasheet view, it shows all the people rather than only the people from the mentioned group. pls help

Can edit in Datasheet View


I have a user in my site collection who cannot edit a list in Datasheet view. When he tries to make an edit he gets the following error: 

"The Web application at filepath.aspx?ShowInGrid=TrueView={long ID number} could not be found. Verify that you have typed the URL correctly.  If the URL should be serving existing content, the system administrator may need to add a new request URL mapping to the intended application."

Other site Members with access to this list do not experienced this behavior.  Can anyone advise me what to look for?

There are no mistakes; every result tells you something of value about what your are trying to accomplish.

Edit a Microsoft InfoPath Form in SharePoint Datasheet view

Hello- I created a form in Microsoft InfoPath 2003 then published the form in Microsoft SharePoint 2007. I then populated the form with test data and submitted it. I would like to know if the "Edit in Datasheet" under Actions will allow me to edit a submitted Microsoft InfoPath form in SharePoint.  I have administrative rights to the SharePoint site however when I review my sample submission in datasheet view, it indicates in the right corner, "Read Only. Am I doing something wrong or is there no capability to "Edit in Datasheet" for 2003 InfoPath forms?  I have used both SharePoint and InfoPath for a few years but am no expert by any means.  Is there a simple solution to this question?  Will progamming be involved?  If so, is there a link available to walk me through the process.  The key is that individuals must be able to edit their submitted form using a datasheet view.  If the end user makes any changes within the datasheet view, those changes should also update the original form that was populated.

Edit in Datasheet allows overwritting calculated field formula.



I discovered some unexpected behavoir while editing an item in a list while in Datasheet view.  I was able to overwrite a calculated field's value with a value I typed in.  I was shocked that I was able to even mouse into that caculated field's column.  When I changed the value for that field and tabbed off it, a message box appeared prompting me to preview the change and that the operation whould be timeconsuming.  I clicked "ok' to continue and discovered that each column in the table had changed to the value I entered for each row in existence.  If I go back into the list settings to see the formula for the calculated field, I notice that the formula has changed to equal the value I typed in Datasheet view.  This can't be good.


Here are some steps to reproduce.


1. create a list or document library

2. add/create a new column, select calculated field with some numberic formula eg = 3*4, be sure to select number as the return data type.

3. add a few new entries to the list or library.

4. select edit in datasheet.

5. attempt to edit the value of the calculated field with some numberic value.

6. you may be prompted for a username/password if the signed in

Approval Status Value and Version missing in "Edit in datasheet" and "Export to Excel "


Hi there.

Anyone knows how to show the WF approval status value (Approved, In process, Rejected...) and the version column from library and list to xecel download (Export) or in datasheet?

Your expert advise will be much apprecaited.

Inplace Edit in GridView

In this article I am presenting a different way to look at EditItemTemplate, using which user navigation for editing is reduced and . it looks very different (see screeen shots) then regular implementation of GridView.

Edit GridView Individual Cells in ASP.NET

The ASP.NET GridView allows for a row of data to be edited by setting the EditIndex property of the GridView, placing the entire row in edit mode.

You may not want the entire row in edit mode if you are using DropDownList controls for several columns in the EditItemTemplate. If each DropDownList has many options then loading them all at once may result in a sluggish page. Also, if your data structure is more like a 2 dimensional array rather than a set of rows, you may want to edit each cell individually.

Here I will demonstrate how to achieve this and also how to deal with event validation without disabling it.

ASP.Net Gridview Edit Update Cancel Commands

In ASP.Net 2.0, GridView Control also provides the functionality to edit and update the data retrieved from the database using CommandField template. You can cancel the action using Cancel Command of the CommandField. GridView consists of events that can be used to perform the actions like edit, update and cancel upon the Data items displayed in the ASP.Net GridView Data Control.

Edit Individual GridView Cells in ASP.NET

The ASP.NET GridView allows for a row of data to be edited by setting the EditIndex property of the GridView, placing the entire row in edit mode.

You may not want the entire row in edit mode if you are using DropDownList controls for several columns in the EditItemTemplate. If each DropDownList has many options, then loading them all at once may result in a sluggish page. Also, if your data structure is more like a 2 dimensional array rather than a set of rows, you may want to edit each cell individually.

ASP.NET GridView - edit records using JQuery Dialog

There are many ways in which you could modify modular data in Grid View:
1. Inline by making rows editable when u click on Edit
2. By using separate pages for Edit
3. By using popups/dialogs for adding/editing

Gridview Edit on Searching of Record


using Asp.net c#

sql server

i am searching a record from my database and displaying it in gridview now i want the comments should be updated as per the record which is being searched

For E.g if record No.3 is searched then only i can update record no.3 and i don't want rest of data to be shown

now what is happening when i click on edit my whole table is being displayed

this is bcuz i made one method gridfill() which i m calling everytime if i m doing grid row editing,row cancelling and row updating

how i can resolve this thing

my code

 protected void GridView2_RowEditing(object sender, GridViewEditEventArgs e)
        GridView2.EditIndex = e.NewEditIndex;


 protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e)
        string id = GridView2.Rows[e.RowIndex].Cells[0].Text;
        TextBox t;
        t = (TextBox)GridView2.Rows[e.RowIndex].Cells[2].Controls[0];
        string query = "update user1 set comments=@comments where id=@id";
        SqlConnection con = new SqlConnection(connstr);
        SqlCommand cmd = new SqlCommand(query, con);

How to let user edit selected gridview columns, not entire row



I've got a gridview I would like to let the user edit a couple of columns.  Seems like everything I'm coming across so far makes the entire row editable.  

Hopefully the solution isn't too complicated.  Can someone point me in the right direction?


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