SharePoint Dragons

Nikander & Margriet on SharePoint

The datasheet view is greyed out and the Open With Explorer button is gone too

What’s the matter when the datasheet view of a list is greyed out? And what’s up with the missing Explorer button? This is totally unrelated to the fact whether Office was installed or not and which version. It is related to two things:

  • The currently used browser needs to be MSIE.
  • It needs to be the 64 bit version.

SharePoint uses JavaScript to check this, and if you don’t meet these prerequisites, you won’t see the datasheet view or Open with Explorer button.

4 responses to “The datasheet view is greyed out and the Open With Explorer button is gone too

  1. eibenh May 22, 2012 at 9:19 am

    Is there typo? Shouldn’t you need to run the 32-bit version of IE? Also: if you installed the 64-bit version of Office 2010 you can’t use the DataSheet-View as well.

  2. Bradley Garner May 22, 2012 at 2:49 pm

    I agree with eibenh…something doesnt seem right, what are your sources?

    • Nikander & Margriet Bruggeman May 24, 2012 at 10:25 am

      We really have a hard time finding back the source, it was from a MS employee in the TechNet forums, but as of yet we failed to dig it up again. Hopefully, we’ll be able to revisit this topic in the near future, as there are some loose ends to this story.

  3. Alex C July 11, 2012 at 3:35 pm

    This worked for us — we used the 64-bit IE and the Datasheet View became enabled; on the 32-bit, it was grayed out. Thanks 🙂

Leave a Reply

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

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

Facebook photo

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

Connecting to %s

%d bloggers like this: