Forum Discussion
Form can not send data to sheet - in company domain
Dear sir, Company domain: catensys.com We use Microsoft enterprise platform, we found one issue today: When we submit form answer, it do not send data to sheet. Form record list 4, but sheet only...
Try to fix by the following:
- Open the Workbook in Excel for the Web
- Go to Excel Online and open the linked workbook from OneDrive or SharePoint.
- This will trigger the new sync engine to pull in missing responses.
- Update the Sync Connection
If you see a message like “Forms is no longer syncing”, follow these steps:
- Click the “Update sync in Excel” button in the right-side pane.
- Wait for the green success bar confirming sync update.
- Rename the Workbook (if needed)
If sync fails:
- Rename the workbook to remove special characters like #, %, {}, etc.
- Save and retry the sync update.
- Avoid Keeping the File Open Continuously
If someone keeps the Excel file open all the time (especially in desktop Excel), it may block sync. Try closing it and reopening in Excel for the web.
- Sync to a New Workbook (if all else fails)
- Go to the Form’s response page.
- Click “Sync to new workbook” to create a fresh connection with all responses included.