onedrive for business – How to update Microsoft Form responses when values ​​are updated in the corresponding spreadsheet?

Desired behavior

  1. Public User A Microsoft Form submits filling a connected spreadsheet in real time.

  2. Company Users you can edit responses within the connected spreadsheet.

  3. The data presented in the Responses The Microsoft Forms interface tab reflects the updated values.

Current behavior

Currently after Company Users edit the spreadsheet, the data presented in the Responses Microsoft Forms interface tab shows data as originally entered, instead of displaying the new values.

Question

How can I make the data presented in the Responses Microsoft Forms interface tab shows updated values ​​from connected spreadsheet, instead of original sent values?

Steps to replicate

Create a form through:

OneDrive file list > New > Forms for Excel

This will forward you to the Microsoft Forms interface.

Click on the Responses tab and the Open in Excel link, which will create a spreadsheet where the responses are added in real time.

Edit values ​​in the responses in the connected spreadsheet.

Click on the Responses tab in the Microsoft Forms interface.

The data presented will reflect the values ​​as originally entered, rather than the updated values.