Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 5 down vote favorite

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

share|improve this question

5 Answers

up vote 4 down vote

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
up vote 3 down vote

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
up vote 3 down vote

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

share|improve this answer
up vote 3 down vote

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
up vote 0 down vote

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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