Forum Discussion
Deleted
Jun 04, 2018Forms for Excel results duplicating in Excel online
Hi, I'm having some issues with results duplicating by itself non-stop every time a user submits a response. Basically, when a user submits a response, the Form writes to the Excel workbook and p...
Peter Mackell
Oct 31, 2018Copper Contributor
I am having the same issue, but cannot find a solution. Please let me know if anyone has figured out why this is occurring.
Vishal DSouza
Nov 01, 2018Copper Contributor
I haven't seen any solution to this problem as yet. As a work around, you will need to delete responses from the form. Your data will still be available on the excel that is linked to the form. Doing this will stop the form creating duplicate entries. Then, go to Excel, select the Date column and click on "Remove Duplicates". The date column has time captured in it along with the seconds, so all unique records will remain and duplicates erased.