SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

On my list the datasheet button is greyed out. How do I go about enabling it?

share|improve this question

Just on the off chance: You are using Internet Explorer, right?

If not, I'm afraid this is an IE-specific function; as I discovered when trying to pry it open with Chrome's dev tools.

share|improve this answer

Do you have the Microsoft Office client software (32-bit version) installed on your computer? This is necessary to support this function. You may also need to enable ActiveX controls if this is disabled in your browser.

share|improve this answer
I believe I am running office 64 bit. That could be my problem. Will test on a 32 bit machine. – Ricky May 24 '11 at 14:47
Yes, you need the 32-bit version of Office. It does not need to be on a 32-bit machine, you can install 32-bit Office on either. Microsoft recommend using the 32-bit version in most cases. – SPDoctor May 25 '11 at 7:44

It could also be turned off for the list. Check the List Settings > Advanced Settings, 'Datasheet' section.

share|improve this answer

As SPDoctor stated - it sounds like an issue with 64 bit install of Office. You cannot view a list in Datasheet view after you install the 64-bit version of Office 2010

Try installing the 2007 Office System Driver: Data Connectivity Components

share|improve this answer
this is 25 MB installer and resolved my issue in IE9 and after updating to IE10 . actual name in add remove is "Microsoft office 2007 access database engine" – imanabidi Oct 27 '13 at 10:11

If you are you using IE11, To sort out this issue temporarily, try to change the document mode of the browser to 7/8/9/10. It worked for me by doing like this.

share|improve this answer

I have found that the 64-bit issue runs a little deeper. If your Office is 32-bit and IE is 64-bit, it seems to do the same thing. Once both are 32-bit, the datasheet icon becomes active.

share|improve this answer

It's IE 64-bit! Kills Flash & other things too. It shouldn't have been released in its current state, and I only use the 32-bit version in Windows 7.

share|improve this answer
Do you have any online reference of your answer? – Benny Skogberg Jun 25 '13 at 19:08

I had similar issue .Please try adding the site to Compatibility View in IE , this might fix your issue.

share|improve this answer
Could you add additional details regarding how to do this? This would improve your answer's quality quite a bit. – Robert Kaucher Mar 28 '14 at 19:45

Do you have a filter(data connection) on the datasheet view from another web part? If yes I am afraid you cannot display the list view on datasheet view. The datasheet view does not allow data connections.

share|improve this answer

protected by Eric Alexander Mar 28 '14 at 17:18

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.