Forum Discussion
Likert Data missing
Hi - looking for some help! I have created a form - and the survey has gone live - 150 responses so far. In this form, I used several Likert questions where I asked questions like "What level of in...
Neale2020 I stumbled on this thread when I had the same problem today. I found a solution!
Go back into the survey builder and update the question, adding values to all of the intermediary options in the likert scale. I backed up my data and printed my results first as a precaution, but it didn't end up being necessary.
Once you've done that, https://support.microsoft.com/en-us/office/how-to-get-missing-data-in-forms-9fb98299-4dcc-41a4-bb29-34a9c3daf8cc Re-open the spreadsheet and your new values should appear!
MS really needs to fix this issue or at least warn people before surveys are launched but at least there is a workaround
- Confirmed that this works great. Thanks for sharing this solution. Agreed that MS should sort this out, I was a bit panicked when I opened the spreadsheets. Even "View Details" shows the data as blank in Forms.
