Having Datasheet View Issues?

If you’re using Office 64-bit and you’re having issues with SharePoint’s datasheet view, this post is for you.

Our team recently upgraded the software on our equipment and Office 2010 64-bit was our chosen Office version. Soon after, people started asking why the datasheet view was no longer working.  It just so happens that SharePoint’s datasheet view doesn’t play nice with 64-bit client software.

Why? The datasheet view uses a 32-bit ActiveX control. Internet Explorer 64-bit disables the datasheet view and without a 32-bit Office install IE 32-bit will give the following error:

Don’t fret though. There will be no need to downgrade to a 32-bit version of Office. This problem can be fixed by installing the 2007 Office System Driver: Data Connectivity Components. Once the downloaded AccessDatabaseEngine.exe is installed, the datasheet functionality should work in both SharePoint 2007 and SharePoint 2010.

Is your favorite application portable?

I just have to mention one of my new favorites. The website www.portableapps.com has a great program suite for portable applications. Their suite works with most portable hardware (USB flash drive, iPod, portable hard drive, etc.) and for those that do not wish to use the entire suite they also have a pretty nice library of portable applications. Best of all – its completely free.

I personally use their Lite Suite. OpenOffice was a bit much for me to put on a thumbdrive and between the Lite’s AbiWord and the fact that most pc’s have office software I decided against it.. I’ve customized it a bit so with the suite I always have Firefox, Filezilla, Notepad++, Foxit Reader, and 7-Zip just a few clicks away on any computer.

Thanks PortableApps!