Forum Discussion

Brian Wyzlic's avatar
Brian Wyzlic
Copper Contributor
Nov 03, 2017

Multiple Answer "Choice" Answers not Populating Excel Spreadsheet

I created a Form through OneDrive using Forms for Excel that had two "checkbox" multiple-choice questions. To clarify: two "choice" questions that allowed users to choose multiple options for each.

 

Two questions related to this:

1. Is there a way to toggle my visual data results between pie or bar charts? The pie charts are not very useful to me, but a bar chart would help a lot.

2. The Excel file generated from these results is completely empty. There is no header row with the questions...just nothing. Where I would expect to see a sheet named "Form 1," I instead see a sheet named "_56F9DC9755BA473782653E2940F9," and again, it is entirely empty. Is this because of the question type, or is there something else going on here? And if it is the question type, is there a plan in the works to allow that data to be viewed in an Excel workbook?

 

Thanks,

Brian

1 Reply

  • Have you tried using Microsoft Forms? It is ultimately supposed to replace Excel forms/surveys and has some great additional functionality.

Resources