We are using MS Forms for Excel to collect some data from users.
Initially, the form was saving data to the excel on the sharepoint document. Recently, we see that the data is not written to the excel file automatically after form submit. Data are synced only when selecting "Sync all responses to a new workbook.
Can you suggest us on what we are missing and possibly result in not saving the data automatically after form submit?
Note: We can sync data by selecting "Sync all responses to a new workbook" however we do not want this to be done as the file name keeps changing every time and had to look for the latest file.