Share via

Microsoft Forms Data and Excel Error

Anonymous
2024-03-19T09:42:28+00:00

I have an MS forms. When i have opened the data in excel, I have the spreadsheet of raw data. One of my questions asks whether something is new or existing, which an option to select 'new' or 'existing'. After this question, the follow mandatory question asks what was done, with options to select 'referred', 'escalated', 'resolved'. For the entries where 'new' was selected, the raw data is then showing me which option was selected for the following question. However, for entries where 'existing' was selected, the answer to the following question isn't pulling through to the spreadsheet. I have cross-checked the responses in the responses tab of MS forms manually, and can see answers to this question for each. Why are these answers not pulling through?

I have reopened the data in excel or different browsers, but the worksheet still shows no answers to these.

Microsoft 365 and Office | Microsoft Forms | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-03-19T12:09:04+00:00

    Hi Abbi,

    Thank you for reaching out. My name is Furkaan, a user just like you. I’d be happy to help you with your concerns. There are a couple of reasons why the answers to the "what was done" question might not be pulling through for "existing" entries in your spreadsheet:

    1. Conditional Logic in MS Forms:

    It's possible you have conditional logic set up in your MS Form. This means the "what was done" question might be hidden or skipped depending on the answer to the "new/existing" question. Check your form settings for any branching logic or conditional questions. If the "what was done" question is hidden for "existing" entries, it won't be populated in your spreadsheet. 2. Filter View in Excel:

    It's possible your Excel spreadsheet has a filter applied that hides the rows where "existing" was selected. Check the filter dropdown arrows at the top of each column. If there's a filter applied to the "new/existing" column, it might be hiding the relevant rows. 3. Refreshing the Data Connection:

    Sometimes, the data connection between MS Forms and Excel needs a refresh to pull in the latest information. In Excel, you can try refreshing the data connection. Go to the "Data" tab. Click on "Get External Data" > "From Other Sources" > "Refresh All"

    I hope I can find a satisfactory solution to your problem. If you have any additional questions or concerns, please don’t hesitate to reach out. Best Regards, Furkaan

    Was this answer helpful?

    0 comments