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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s