SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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

I have created a cascading lookup column field for a list in sharepoint 2010. It's working fine in the Standard view but not in the DataSheet view.

In datasheet view it is showing all the possible options in child column; it isn't applying the parent column's filter.

For example: If you select the country India in the parent column, it should only show Indian countries in the child column; but in the DataSheet view it's showing all the other options.

How can I change the behaviour of the child column to filter the available options??

share|improve this question

The DataSheet view is unfortunately not customisable; SharePoint uses Access to render the sheet, which uses its own controls and methods.

share|improve this answer
Hi stuart, thanks for ur reply. you mean, it is not at all possible to filter the content of child column of a list in a datasheet view? Then how to enable cascade lookup dropdowns for datasheet view? please give me solution for that – suresh Jul 22 '11 at 11:59
@Suresh: I'm afraid there is no solution that I'm aware of. – Stuart Pegg Jul 22 '11 at 12:00

You may also want to try KWizCom's list inline editor. This SharePoint add-on works in all browsers and also allows you to bulk-edit items that include custom columns:

share|improve this answer
We require relevant answers and disclosure of any affiliation with products or websites. Please see May I promote products or websites I am affiliated with here? for guidelines. – SPDoctor Feb 29 '12 at 11:37

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.