Hot answers tagged 2007
Datasheet views don't support Web Part Connections and instead of ignoring them, unfortunately they just fail to display. In order to make this work you should create and view and then use DataSheet view for editing.
You can add lookup columns to Site Collection parent site and have it reflect as lookup within child sites by creating the site column as lookup. But cross site collection, it is not possible OOTB. There are 3rd party solutions available if you search for "Sharepoint 2007 Cross Site lookup".
Only top voted, non community-wiki answers of a minimum length are eligible