I'm using the XL2007SynchronizeWSSandExcel Excel plugin to synchronize and maintain SP lists in Excel, and I'm running into a major constraint. When I initially import the list into Excel to configure the synchronization, columns that are of type People and Groups get imported to Excel as plain text fields, not as a drop down list. When I then publish the list to SP as a synchronized list, the People and Groups columns are created as column type Single line of text.
I've done some research and it does not appear that you can convert a column of type Single line of text to a column of type People and Groups in SP. Does anyone know if it's possible to force Excel to recognize and respect column types when using the XL2007SynchronizeWSSandExcel plugin?
Thanks.