in the SharePoint group "ChangeUser Owners" are the following people listed:
- DEMO\Administrator (Administrator)
- DEMO\hans.meiser (Hans Meiser)
- DEMO\ilona.christen (Ilona Christen)
for example in a Task List you want to filter the people that are displayed in the "assigned to" column. You just want to display the people from a specific SharePoint group like "ChangeUser Owners" as shown in the picture below:
Now just create a Datasheet View of this task list.
In Office 2010 this Datasheet View will be displayed as shown in the picture. Only people from the selected group are shown.
In Office 2007 and Office 2003 the groups are not filtered out!! I couldn't believe it, but if you take a look at this list with Office 2003 and Office 2007 this will be displayed as:
Conclusion: Maybe i'm doing something wrong. But in my case this only works with Office 2010.