I'm having a simple problem. I've created a SharePoint list for users
to export to excel, make their edits in excel, then sync it with the
SharePoint list. That part works no problem.
The problem is just with one field, which is a Multiple Choice field.
Although it is set in SP to be a multiple choice field, when it is
imported into Excel I can't find a way for the users to be able to
choose multiple values.. and I can't change the data validation since
it's set from SP.
Also, If i just go into datasheet view via web and try and edit that
field.. I can make multiple choices through that no problem.
So my question is.. how can I make it possible for the user to choose
multiple values when they are in excel??
Do you know someone who can help? Share a link to this thread on twitter, or facebook.