4

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?

6

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 Aug 20 '12 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 Aug 20 '12 at 10:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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