When you create a form in OneDrive for work or school, SharePoint Online, Excel for the web, Microsoft Teams, or using the Microsoft Forms web part, you can select Open in Excel to get an Excel workbook (automatically stored on OneDrive for work or school or SharePoint Point Online) that contains a live data connection to your form. Any new response data in your form will be reflected in your workbook.
Deleted workbooks, file corruption, or other problems may prevent display of the latest data. If those things happen, Forms will give you an alert and ask if you want to create a new workbook that syncs with your most recent responses. This makes sure your data is up to date. You'll see the new workbook next to your original workbook on OneDrive for work or school or SharePoint Online. Learn more about how to get missing data.
Note: Workbook sync issues will occur if you require content approval for items in SharePoint. To learn more, go to Require approval of items in a site list or library, and then select the section, Specify that items in a library require approval. Review step #4. If you select Yes for the Require content approval for submitted items? option, your workbooks will not sync.