Forum Discussion
Use Microsoft Forms to edit an existing row in Excel online
You may first create the Form connected to your Excel file. It creates structured Table. Without changing this table columns names you may add existing data from other source to the table.
Each time someone fills the form new row will be added to the table, it won't affect already entered into the table data.
Moreover, you may add another columns to that table (e.g. for comments, whatever), and add into such columns information manually.
What is important, columns linked to the Form shall not be changed. I don't remember now they are linked by internal ID or by names, in any case it will be more reliable to keep created by Form columns as they are without modifications. Data and other columns could be added manually.
All above is quite easy to test before deploying final variant into production.
You may first create the Form connected to your Excel file. It creates structured Table. Without changing this table columns names you may add existing data from other source to the table.
Each time someone fills the form new row will be added to the table, it won't affect already entered into the table data.
Moreover, you may add another columns to that table (e.g. for comments, whatever), and add into such columns information manually.
What is important, columns linked to the Form shall not be changed. I don't remember now they are linked by internal ID or by names, in any case it will be more reliable to keep created by Form columns as they are without modifications. Data and other columns could be added manually.
All above is quite easy to test before deploying final variant into production.
- Thank you for your help Sergei!
Markus_Espeter , you are welcome
