I figured it out!!
Ok, so here is how you take excel data and make it populate to a multichoice field:
put all of the entries that you want in the multichoice list in one column in the excel sheet deliniated by ;# in front of each and then another ;# at the end of the list.
Example:
The...
Thanks for the response!
I tried your suggestion and have been playing with it all morning but have been unable to get it to work still. I can link the spreadsheet and sharepoint list together without any problem, but I havent been able to get it to populate a multi choice field.
I am working...
I am trying to cut and paste data from an excel sheet into a sharepoint 2007 list. The data in excel is has multiple entries in each cell (eg: left, right, up, down). I would like to paste it into cells that have been formated for multi-choice checkboxes so that the ckeckboxes are checked...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.