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

How to I get an External List in Datasheet View? I have a List, whereby I have Looked up a Column from an External List. The column appears as readonly in Datasheet View, but behaves normally using the normal view.

Any solutions?

share|improve this question
up vote 6 down vote accepted

This is one of the limitations of an external list; there is no way to get a datasheet view with the built in functionality of SharePoint.

Other limitations are quite well ennumerated on this blog post. As you can see, there are quite a few of them and it is worth bearing these in mind when designing solutions with the Business Connectivity Services.

share|improve this answer
Any possibility of using Javascript to solve? – neo269 Aug 20 '12 at 9:53
I don't think so, with the standard external list. There is a third party web part available from layer2 that claims to allow it, but I haven't tried this out yet. – TZHX Aug 20 '12 at 10:24

Your Answer


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.