I've got this xls workbook which contains a two-way synchronized SharePoint list.
This WSS list contains columns which are related to other lists: for instance the list we're using is a list of assignments, where an assignment is related to an accounting period. Our server also has another list with all accounting
periods. Both lists are related since the assignment list as an accounting period column of lookup type which uses the accounting period list as a source.
In previous versions of Excel, the output is that the accounting period field is a combobox populated with all availalble accounting periods. Thanks to that, the user can easily link an assignment to an accounting period by selecting a value in
this combobox and synchronizing.
This works great with Excel 2003 and 2007, however in 2010 (same workbook, consuming the same lists) related information doesn't appear. The combobox is empty and as a consequence the user gets a data validation error since the value in the cell
isn't among available values.
Is there something special I should do to enable this feature in Excel 2010?
View Complete Post