Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

SharePoint List Export To Excel - Multiple Choice fields

  Asked By: Alvin    Date: Mar 29    Category: Sharepoint    Views: 6462

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??



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.