.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

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

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :SharePoint
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?

View Complete Post

More Related Resource Links

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.

SharePoint 2007 - How to associate a Custom List View with a Custom Edit Form. Edit link always re


Can someone give me a clue of how to connect a specific Custom List View with a custom Edit Form.

I have created a custom list, and I have created a custom view attached to that list.   I also have a custom CustomEditForm.aspx form created using SharePoint Designer.

I want to associate the Custom Edit form directly with one and one view only for a given list so that when the user clicks the edit icon in that view, they are linked to the custom Edit Form.  But all other views including the All Items view behave as normal, i.e. using the normal EditForm.aspx.

I can replace the EditForm.aspx in the Url with my custom form and it works fine, but I can't seem to figure out how to connect the custom view edit link to the custom form.  It always takes me back to the default EditForm.aspx page.

I have investigated the href="{$URL_Edit}?ID={@ID}" onclick="GoToPage('{$URL_Edit}?ID={@ID}') in code, which appears to  be how the URL is generated but I'm not sure how or where best to set the value of URL_Edit parameter so that I point to the custom Edit Form.  This is somehow getting passed into the custom view, but I'm not sure how best to set it for a specific non-AllItems view.

Does anyone

Sharepoint 2007 View Problem

I have a document library in Sharepoint 2007 in which I have seet up a number of different views so that the users who work with the information in that library can filter down to the specific area that they work with.  The view itself works great, and they are able to see their data quite easily.  The problem comes when they actually go in and edit any of the items.  Unlike most software in the civilized world for the past 30 years, the user is not returned to the view that they were working with, but to the defult view.  This means that any task where they are required to do many edits at a time becomes a frustrating nightmare and waste of time.  Is there any setting I can change, or anything else at all that I can do to give my users a little relief by making the site navigation such that they are returned after an edit to the same view that they were in before the edit?  Ideally, it would be nice if the same scroll position within the view were returned as well, but I suspect that I may be asking for too much by pushing that issue.  HELP! HELP!  Any and all constructive assistance is appreciated.

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!

How do I get the Sharepoint 2007 KPI to use the "Calculation using all list items in the view"

I have a custom SP list that contains a numeric column in the list and the view selected for the KPI. The option to calculate using all items in the view is grayed out.  Sometimes SP will let me create a KPI like this, then I go back to the webpart and the indicator has reverted back to just a simple count of the number of items in the list.  I want to use the "calculate all items" from a numeric column and have my KPI stay that way? Any thoughts?

Access Denied while using Sharepoint designer 2007 to create a work flow

I am using Sharepoint Designer 2007 to create a work flow that sends emails to different people in a group depending on status of a record. For example, when some one reports a problem, an email is posted to concerned person and as soon as he/she checks the problem and updates the status an email is sent to next department and so on. Starting the work flow creation wizard is no problem but as soon as I press 'Finish' to create workflow I get 'Access Denied' message box. Any Ideas? I am using WSS 3.0 on 2003 Server.

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

Uploading Excel 2007 table into WSS 3.0 - How does SharePoint decide the column that is used to edit

Hi, In Excel 2007, there's an option to upload (export) an Excel table into SharePoint.  The range of cells have to be identified as a table.  In the Table ribbon, there's an Export button.  When I upload the Excel 2007 table, SharePoint (WSS 3.0) decides which column in the table will be linked to the properties dialog box for each line in the table.  It seems to be a sporadic decision on the part of SharePoint. Does anyone know how WSS 3.0 decides which column will be linked to properties?  And, is there any way to control this when uploading the file? Thanks!Thanks! Patti N.

Conditional formatting on a joined subview using SharePoint Designer 2007 does not work

I have 2 SharePoint lists, one is a parent task list and the other a child task lists.  In SharePoint Designer 2007 I have created a combined datasource from these 2 lists.  From there I created a new ASPX page inserting the parent list as a dataview and the child as a subview.  So far so good, all is functioning as you would expect.    Now I need to apply conditional formatting to cells and rows in both the parent and child lists.  I can create a very simple condition on a row or cell of the parent list such as "If ID Equals '2988' format the background color as green" but no conditional formatting appears for the row where ID = 2988.  Incidentally, if I change the condition to "not equals 2988" the background changes to green. The line in the code view of Designer appears as follows:  <xsl:if test="../../../Rows/Row/@ID = '2988'">background-color: #00FF00;</xsl:if> I've seen this question asked here and in blogs but never answered.  If anyone has a solution, I would love to know what it is. Thanks; Dave  UPDATE:  it doesn't seem to matter if you add the additional fields as a joined subview or not.  If I add 2 data views, both using the linked data source which is configured to JOIN the contents of the data sources the conditional formatt

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.      

SharePoint 2007 - Windows 7 - Explorer View (Leaves a copy in recycle bin)

Hi All, I am facing a strange problem with SharePoint 2007 & Windows 7. I open an existing word document from my PC(Windows 7) and click "save as" and provide a SharePoint document library file path (\\machinename\sitename\DocumentLibraryName) and save the file. The word file becomes visible in the Shared document library, BUT it leaves a copy in the recycle bin of the SharePoint site. Works Normal from Windows XP PC. Any clues. Would greatly appreciate anybody's effort. Regards KCM

SharePoint 2007 to 2010 Upgrade AND Farm Merge


Hello all,

I'm curious to see if anyone has done this.  Currently, my environment has 3 seperate SharePoint 2007 server farms.  I'm currently evaluating SharePoint 2010 and so far like what I see.  I'm wondering though what would be the steps I would need to go through to actually upgrade and then merge them all to one SharePoint 2010 farm?  The steps I can think of are the following:

1. Make sure all 2007 farms are on the lastest (or at least similar) version

2. Upgrade each farm to SharePoint 2010

3. Create new 2010 farm

4. Copy upgraded farms' site collections to NEW 2010 farm.

OR can I do this:

1. Make sure all 2007 farms are on the same version

2. Create a copy of each current SharePoint 2007 site collection that I want

3. Create NEW 2007 Farm

4. Copy content to new farm

5. Upgrade new farm to 2010


Any and all help would be greatly appreciated, thanks!


Reg: Does Custom site definition created in SharePoint 2007 works in Sharepoint 2010



If one has created a custom site definition in sharepoint 2007, Once the whole site is migrated to sharePoint 2010 will that "custom site definition" created in 2007 will work without breaking in SharePoint 2010?

If No, what has to be done to make it work on 2010.






OOTB Approval Workflow SharePoint 2010 - Blank "Requested By" field appears in Task Item edit/view f



I am having a simple OOTB  approval worflow associated to the simple document library. Task is created when an document is uploaded to the library.  When I click the task item in task list, I see a blank field "Requested By"  right below the "Status" column and I am unable to understand from where this field is coming and how to populate this field. Any help would be great...

Win server 2003+ Sharepoint 2007+SQL Server 2008 ,reports view issue?


I hope someone may shed some light on a serious obstacle encountered on a client site:

We have implemented a SharePoint integrated report services solution for the client on a single server

Server = Windows 2003

SQL = 2008

MOSS 2007

Web application = servername:8888 (default) - windows auth

Web application extension 1 servername:8889 (extranet) forms auth

Web application extension 2 servername:8887 (intranet) forms auth

Reports are visible and can be run (renders) on internal sites

However, there is an external site which allows users to access the reports - the issue is, the reports then dont run and I get this:

"An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode."

Though I have not actually seen the firewall config of the AAM, the client assures me it has been setup properly.

If the AAM is setup correctly, what could be the problem? The server is clearly available and confgured in SharePoint integrated mode.


has anyone experienced the scenario where clients want to publish their reports on an external site? What can one do to see any errors other than the one line message (tried enabling custom errors, but no good)

Sharepoint 2007 View, append url with Javascript and reload page


Hi all. I have an odd requirement.

I have created a number of views for a custom list I have created. I need to be able to filter these lists by what "Quarter" we are currently in (Jan-Mar - 1; Apr-Jun - 2; Jul Sep - 3; Oct-Dec -4) compared to when the item was created (i have a calculated column that uses the created date to have the quarter). Each view is a new page (as you have created a view from within Shaarepoint)

I haven't been able to work out how to do this in the CAML query (as I can't figure out how to reference todays date in CAML).

With this out of the question, I then tried to use the Today column hack, but as this isn't dynamic, this doesn't work.

My final efforts now revolve around using a basic javascript function to append my url with the following:

?FilterField1=CreatedQuarter&FilterValue1="+ currentQuarter;

Does Sharepoint new Client Object Model works with SharePoint 2007


I am able to test this new Client OM successfully with SharePoint 2010.


Would it support SharePoint 2007 & SharePoint 2003?


How do you retrieve data from older SharePoint Server ?

Ronak Patel
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