Teams Form not showing multiple choice answers in Excel

Occasional Visitor

In a basic Teams form, I have a couple of questions with choices for responses. The chosen response is not showing up in the Excel spreadsheet.
For example: "What type of staff member do you need?" Choices are: RN, HCA, Admin, Volunteer, etc. 

In the Excel spreadsheet summary of responses, this question cell is blank. It doesn't pick up whatever the respondent selected.

How can we see the responses to 'choice' questions?

0 Replies