Forum Discussion
Mikulof
Jan 08, 2025Copper Contributor
Forms update
I use MS Forms for collecting data to excel file and frequently make corrections to typos and wrong entries. If I now update my existing Forms as instructed, will the corrections/alterations get ove...
Kidd_Ip
Feb 24, 2025MVP
When you update your MS Forms, the data collected in the Forms is stored on Cloud and linked to your Excel file. If you make changes to the Form itself, it should not overwrite the existing data in your Excel file. However, if you re-upload or re-import the Form, there is a risk that the data might get overwritten.
To avoid losing your corrections:
- Backup Your Data: Before making any updates, ensure you have a backup of your Excel file with all the corrections.
- Export Data Regularly: Regularly export the data from MS Forms to Excel to keep a local copy of all responses.
- Use Version Control: If possible, use version control for your Excel file to keep track of changes and revert to previous versions if needed.
- Test Updates on a Copy: Before applying updates to your main Form, test them on a copy of the Form to ensure that no data is lost.