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?

1 Answer 1


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.

  • Any possibility of using Javascript to solve?
    – neo269
    Commented Aug 20, 2012 at 9:53
  • 2
    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
    Commented Aug 20, 2012 at 10:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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