Forms to Excel Output After Editing
I have a form that outputs to a workbook where data is then run. I needed to add additional questions to the form and now the new responses will not show up in the workbook. When editing the form itself, it indicates that all of the responses still exist, but when I click on the "open in Excel" button, the responses submitted after the form changes are not there. I am not sure if this is relevant but I also notice when I'm on the workbook it says "SharePoint App is also editing." Does anyone know how to sync my answers with the current workbook?Forms Responses in Excel are hard to read
Hi there, I have a form that I'm trying to submit to clients with roughly 80 questions on said form. I'm trying to avoid making them sign up for an email/username through microsoft, so I've included a "First and last name" question to sort the responses. My questions is, with 80 questions and 200 some clients, when I display the responses in excel it's very difficult to view them client by client (Because each response is on a different line and I have 80 columns to scroll through). Is there some formatting I can do to individualize the responses. Or even a table option that will allow me to view one form response at a time? Thank you.