Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

SharePoint List Export To Excel - Multiple Choice fields

  Asked By: Alvin Miles         Date: Mar 29, 2009      Category: Sharepoint      Views: 1358
 

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.

Tagged:                

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on SharePoint List Export To Excel - Multiple Choice fields Or get search suggestion and latest updates.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].