.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

Unable to edit in Datasheet View

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

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?

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.      

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.

Unable to Edit the properties of a document using the ribbon


I have created a new web part page and added a document library to that page.  In the ribbon the "Edit Properties" icon is enabled and I can edit the document properties.

When I add another web part to the page and go back to select a document, on the ribbon the "Edit Properties" icon is no disabled.  I can still edit the document using the context menu of the document.

Permissions on the library did not change when I added the additional web part.  The only change to the page was adding an additional web part.

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.


Any ideas how to get this resolved?

Cannot edit datasheet in WSS 3.0. Getting Unresolved errors.

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.

Unable to Show Edit item Links in Data Form Web Part

I have a DFWP connected to custom list and the boxes to Show Edit Item Links, Show Delete item links and Show Insert Item links are grayed out so that they can not be checked. This works fine when I use a DFWP connected to a standard list (i.e., Contacts). Is there something special that needs to be done to activate this functionality?ThanksDean

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?

Designer workflow + unable to edit task

I use the SPD to create a custom workflow which will assign to-do task to users. The workflow is attached to a list library in a subsite and users only have view-only permission to the subsite (users are added to the subsite directly, not inside any sharepoint group).  In order for users to complete the assigned task, I have broken the permission inheritance and change users to have contribute permission on the Task list.   The workflow would trigger as expected and a new task is created for the user. The user can see the "edit task" link in the task item but when clicked "edit task", an "access denied" error occurs.   Under further investigation, I notice access are granted for sharepoint group e.g. site visitors, site members on URL http://....../workflow/workflow_name/newtask.aspx , and only when I create the workflow under the site administrator account. If I create the workflow under an account which also has "Full Control" to the subsite, No access are granted to the workflow library at all.   What permission levels do I need to create workflows in designer really? Does it make a difference if the workflow is on a top-root site or subsite? Full control on the top-root site or subsite?   Thanks in advance.

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  

Unable to open design view

I have SSRS 2008(native), BIDS and VS  2008 (9.0.30729.1 SP) on Windows 7 Pro.I have a working report and today I cannot "View Designer" for my report.When I load the project, it automatically goes into rdl:code view.When I right click on the report, I see the option to view code or view designer,and select view designer, it produces a second copy of the rdl:code view.The rdl is good because: - I can build the project and the build succeeds. - I can run the rdl (right click, run) and it produces the preview of the report.Then, I started a new simple project, went through the wizard and still - no design view.This simple project also builds correctly and produces a preview report.I have checked this, and other forums but I find myself (sort of) alone in this quandary!So, how (and why) did I lose the designer view?Please help....Usman Suleman

Unable to store combo box value to data grid view control

Hello,         I am using fw 3.5 SP1 with VS2008. I have bind my object collection with data grid view. I can see different values in combo box inside data grid view. But when I select any one value from combo box the selected value is changed to first value of combo box as soos as user leave the cell of the gird. Can anyone tell me where should I look for this problem so that my selected value remains same as user did select it.   Nilkanth Desai  

Unable to Edit or Create Page under new subsites Moss 2007

I have created new subsites and trying to create a page, but it shows access denied error. Eventhough i have logged in as site collection administrator and given access as full control for subsite and also tried giving master page and style library read access. when i click on create page, I can enter the page name and after that it shows ACCESS DENIED . but the page is physically created and unable to edit.... Appreciate your help on this Issue....    
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