In forms.office.com we created a form that is backed by an excel spreadsheet.

If I look at the responses and delete one of the responses, the response is gone from the list. However, if I open the excel spreadsheet, the answer is still there. What is unclear to me is, how does it know that the given row in the excel file is "deleted" and should not be visualised anymore? I don't see any additional column with a deletion flag or similar.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.