Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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

1 Answer 1

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? –  saumilm 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

 
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.