Bulk editing issue - list cannot be displayed in Datasheet view
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.
September 4th, 2007 7:11pm
I am having the same trouble here. I think I have narrowed it down to users without MS Access cannot edit items in Sharepoint Lists. I have tested on machines with Office 2002 and they worked except the ones that didn't have the MS Access installed. Hope this helps you.
September 4th, 2007 11:41pm
I loaded MS Access on four of my machines and it fixed them immediately. We use XP Pro and Win2000. Sorry I couldn't help you.
September 8th, 2007 12:59am
a23rd: You have become the victim of Microsoft's poor planning for Office 2003/2007 compatibility. We've been fighting with the same problems here for the past ten months. In a nutshell, the Windows SharePoint Services Support installed with Office 2003 and the one installed with Office 2007 are incompatible. Any Office 2007 product (Project, Word, Access, etc.--even Designer) installed alongside an Office 2003 product will cause a problem. Simplest fix: Completely uninstall all Office 2007 products using Add or Remove Programs. Run a reinstall (a fix/repair alone won't do it) on Office 2003 using the change button in Add or Remove Programs (make sure Windows SharePoint Services Support is installed with Office 2003--may need to do a Fix/Repair with custom settings to check this first). Reinstall your Office 2007 products making sure to do a custom installation with Windows SharePoint Services Support not being installed. Here's the rub: Microsoft's updates to the Office products sometimes cause the Office 2007 components of Windows SharePoint Services Support which cause this problem to be installed. For example, I was doing fine until Microsoft Updates came around and asked me to install the Office SharePoint Designer 2007 Service Pack 1. Soon as I installed the service pack, my datasheet views stopped working and I got the following error message from SharePoint: 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. So, watch when the updates install. Resolution: To completely escape this problem, it looks like the only solution is to abandon all Office 2003 products and upgrade to Office 2007. Note: Don't forget... In order to get datasheet views to work at all, you need to have Office 2003 Professional edition. See http://support.microsoft.com/kb/909506for more information (it talks about WSS2, but the same holds for WSS3).
February 29th, 2008 9:29pm
I don't believe this entirely the case. I'm getting this error on just ONE SPECIFIC WSS 2.0 list on site. If I browse to another list on the exact same site and click on "Edit in Datasheet" it works just fine for that particular list. Another oddity, when I click on "Edit in Datasheet"and get theerror above I just discovered that if Ihit my browsers "back" button(I'm using IE 6) then the datasheet view magically appears!
March 25th, 2008 7:29pm
I am having a similar problem but none of the proposed fixes work. I am running on current releases of Office 2007 Enterprise on a Vista Ultimate Laptop. I have tried the uninstall/reinstall route, no luck. Any other ideas? I need the datasheet capability since I am responsible for my clients SharePoint sites and have to have all features for testing prior to release to clients.
December 2nd, 2008 8:15pm
I have been able to resolve most of these Office incompatibility issues by Just running MS Office Diagnostics.Takes several minutes to run but ususlly fixes the problem (browser crash while opening office doc, unable to edit in datasheet view, others).Start > All Programs > Microsoft Office > Microsoft Office Tools > Microsoft Office Diagnostics
September 21st, 2009 11:36pm
Running diagnostics fixed the issue I was having. Thanks!!
October 19th, 2009 8:25pm
Thanks, Running the Diagnostics worked for me too.
November 5th, 2009 9:04pm
I am using Office 2010 64-bit and it doesn't work because its 64-bit. Any workaround?? Sean I also have the same problem. I'm on Windows 7 Ultimate with Office 2010 64-bit. The error I get is:"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"I tried to install Office Web Components 2003 but that didn't fix it.My understanding is that Sharepoint 2010 will thankfully have an AJAX datagrid (no ActiveX), so I guess I must wait, but it would be nice to have a functional ActiveX workaround.Thanks for the workaround of using MS Access, Sean.Regards,Chris
February 9th, 2010 9:51pm
I have run the diagnostic tool and it fixed the issue for me. I am running Windows XP + Office 2007 + Some Office 2003 (MS Access, Inforpath etc). Thanks.
February 15th, 2010 7:13pm
Well, I'm facing the same problem, Windows 7 Ultimate, Office 2010 64 bit, and anything I do, SP thinks, I'm preventing running activex, etc. Really should I install Access to handle SP 2007 lists in datasheet mode? I'm close to edit the list in SQL Management studio...
May 3rd, 2010 1:10pm
Try installing the 2007 Office System Driver: Data Connectivity Components after you have installed Office 2010 64-bit on the client machine. This should provide you with the edit in Datasheet functionality. Let us know how it works out. Thanks, Jennie
May 13th, 2010 5:55pm
Hi, I had the same problems, solution provided by Jennie works for me. Thank You Jennie!
May 18th, 2010 8:47pm
The list cannot be displayed in datasheet view http://sharepointerrorsslv.blogspot.com/2010/10/list-cannot-be-displayed-in-datasheet.html
October 20th, 2010 3:33pm
I also had the same problems on a Windows Server 2008 R2 64 bit, running Office 2010 64 bit. I installed the 2007 Office System Driver: Data Connectivity Components as instructed on the local machine and did indeed fixed the Datasheet funcitionality. Ditto here, Windows 7 64-bit, Office 2010, IE9. Fixed with the data connectivity components.james . Curtis
June 1st, 2011 4:08pm