Forms for Excel results duplicating in Excel online

%3CLINGO-SUB%20id%3D%22lingo-sub-200428%22%20slang%3D%22en-US%22%3EForms%20for%20Excel%20results%20duplicating%20in%20Excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-200428%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20having%20some%20issues%20with%20results%20duplicating%20by%20itself%20non-stop%20every%20time%20a%20user%20submits%20a%20response.%20Basically%2C%20when%20a%20user%20submits%20a%20response%2C%20the%20Form%20writes%20to%20the%20Excel%20workbook%20and%20puts%20the%20data%20in%20a%20row.%20This%20row%20then%20keeps%20duplicating%20itself%20without%20stop.%20This%20is%20happening%20on%20Excel%20online%2C%20and%20I%20can't%20seem%20to%20find%20a%20solution%20for%20this.%20Any%20help%20would%20be%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-200428%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Apps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-282637%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20for%20Excel%20results%20duplicating%20in%20Excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-282637%22%20slang%3D%22en-US%22%3E%3CP%3ERohit%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20persists%20for%20me%20after%20trying%20to%20start%20multiple%20forms%20from%20scratch.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-281074%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20for%20Excel%20results%20duplicating%20in%20Excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-281074%22%20slang%3D%22en-US%22%3EHello%20Mr%20Woan%2C%3CBR%20%2F%3E%3CBR%20%2F%3EKindly%20try%20checking%20the%20behavior%20on%20a%20newly%20created%20form%20and%20share%20the%20behavior%20with%20me%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-281032%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20for%20Excel%20results%20duplicating%20in%20Excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-281032%22%20slang%3D%22en-US%22%3EI%20haven't%20seen%20any%20solution%20to%20this%20problem%20as%20yet.%20As%20a%20work%20around%2C%20you%20will%20need%20to%20delete%20responses%20from%20the%20form.%20Your%20data%20will%20still%20be%20available%20on%20the%20excel%20that%20is%20linked%20to%20the%20form.%20Doing%20this%20will%20stop%20the%20form%20creating%20duplicate%20entries.%20Then%2C%20go%20to%20Excel%2C%20select%20the%20Date%20column%20and%20click%20on%20%22Remove%20Duplicates%22.%20The%20date%20column%20has%20time%20captured%20in%20it%20along%20with%20the%20seconds%2C%20so%20all%20unique%20records%20will%20remain%20and%20duplicates%20erased.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-280649%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20for%20Excel%20results%20duplicating%20in%20Excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-280649%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20the%20same%20issue%2C%20but%20cannot%20find%20a%20solution.%20Please%20let%20me%20know%20if%20anyone%20has%20figured%20out%20why%20this%20is%20occurring.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-244819%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20for%20Excel%20results%20duplicating%20in%20Excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-244819%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20facing%20the%20exact%20same%20issue.%20Overnight%2C%20there%20are%20have%20been%201000%2B%20duplicate%20entries%20created.%20Please%2C%20can%20anyone%20provide%20some%20guidance%20as%20to%20why%20this%20occurs%20and%20what%20can%20be%20done%20to%20resolve%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-207562%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20for%20Excel%20results%20duplicating%20in%20Excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-207562%22%20slang%3D%22en-US%22%3EWas%20a%20solution%20ever%20found%20for%20this%20problem%3F%20I%20am%20also%20experiencing%20this%20issue%2C%20it%20just%20started%20happening.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1314657%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20for%20Excel%20results%20duplicating%20in%20Excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1314657%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20issue%20still%20exists.%20There%20are%20a%20lot%20of%20duplicates%20in%20the%20results%20and%20I%20cannot%20bulk%20delete%20it%20in%20Microsoft%20Forms%20Online.%20Hence%2C%20the%20charts%20and%20graphics%20shown%20in%20Forms%20online%20are%20not%20accurate%20with%20lots%20of%20duplicated%20results.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1383111%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20for%20Excel%20results%20duplicating%20in%20Excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1383111%22%20slang%3D%22en-US%22%3E%3CP%3EAnyone%20found%20a%20resolution%20to%20this%20issue.%26nbsp%3B%20I%20have%20a%20Forms%20for%20Excel.%26nbsp%3B%20Randomly%20today%2C%20it%20started%20duplicating%20entries%20from%20Forms.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1384658%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20for%20Excel%20results%20duplicating%20in%20Excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1384658%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20a%20test%20form%20and%20shared%20it%20with%20anyone%20can%20answer%20permission%20to%20myself.%20When%20I%20finished%20the%20form%2C%20by%20clicking%20the%20submit%20buttom%20multiple%20times%20before%20it%20redirected%20to%20the%20completed%20interface%2C%20the%20problem%20can%20be%20reproduced.%20For%20anyone%20in%20your%20orgnization%20permission%2C%20it%20actually%20has%20a%20choice%20that%20distincts%20the%20response%20that%20eliminates%20the%20duplicates.%20However%2C%20that%20option%20is%20not%20available%20to%20permission%20%22anyone%20can%20answer%22.%20The%20problem%20is%20if%20I%20want%20a%20lot%20of%20people%20in%20the%20company%20to%20answer%20a%20form%2C%20having%20them%20login%20first%20will%20just%20stop%20them%20from%20answering%20the%20form.%3C%2FP%3E%3CP%3EIn%20conclusion%2C%20%3CSPAN%3EI%20think%20it%20is%20a%20design%20issue%20and%20%3C%2FSPAN%3EI%20guess%20Microsoft%20will%20not%20fix%20this%20or%20add%20a%20%22one%20response%20from%20each%20user%22%20option%20to%20%22anyone%20can%20answer%22%20permission%20in%20a%20short%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1386057%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20for%20Excel%20results%20duplicating%20in%20Excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1386057%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F625613%22%20target%3D%22_blank%22%3E%40Sean_Shen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWere%20the%20duplicate%20entries%20receiving%20the%20same%20ID%20number%20as%20well%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20we%20were%20seeing%20was%20the%20same%20entry%20occurring%20multiple%20times%20throughout%20the%20day%20(i.e.%20I%20submit%20the%20form%20in%20the%20morning%2C%2030%20minutes%20later%2C%202%20hours%20later%2C%202%20hours%205%20minutes%20later%2C%20etc.%20the%20same%20submission%20is%20entered%20again%20in%20the%20table).%26nbsp%3B%20This%20continued%20throughout%20the%20day.%26nbsp%3B%20Then%2C%20close%20to%20the%20end%20of%20the%20day%2C%20a%20new%20spreadsheet%20popped%20up%20in%20the%20SharePoint%20Excel%20file.%26nbsp%3B%20Now%2C%20this%20new%20file%20is%20doing%20the%20same%20thing.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1386074%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20for%20Excel%20results%20duplicating%20in%20Excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1386074%22%20slang%3D%22en-US%22%3EThis%20seems%20to%20be%20a%20bug%20in%20the%20application.%3CBR%20%2F%3EI%20have%20faced%20this%20issue%20as%20well.%3CBR%20%2F%3EThe%20only%20work%20around%20for%20this%20problem%20is%20that%20delete%20those%20duplicate%20rows%20and%20make%20sure%20you%20delete%20them%20if%20that%20happens%20again.%3CBR%20%2F%3EWe%20will%20have%20to%20follow%20this%20until%20MIcrosoft%20releases%20the%20fix%20for%20this%20error.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3ERegards.%3CBR%20%2F%3EAdmin%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.o365cloudexperts.com%2Foffice-365-migration%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.o365cloudexperts.com%2Foffice-365-migration%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1386082%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20for%20Excel%20results%20duplicating%20in%20Excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1386082%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425529%22%20target%3D%22_blank%22%3E%40RuskinF%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAgreed%20but%20sad.%26nbsp%3B%20The%20fix%20should%20be%20fairly%20easy%20%22Do%20Not%20Allow%20Duplicates%22.%26nbsp%3B%20This%20is%20operating%20off%20what%20appears%20to%20be%20a%20basic%20database%20(assuming%20SQL%20compliant%20Db).%26nbsp%3B%20Opened%20it%20today%20and%20noticed%20it%20was%20replicating%20responses%20from%20April%2027th.%26nbsp%3B%20It%20almost%20makes%20the%20application%20not%20usable.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1388034%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20for%20Excel%20results%20duplicating%20in%20Excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1388034%22%20slang%3D%22en-US%22%3ENo%2C%20the%20ID%20of%20each%20response%20is%20unique.%20Per%20say%20I%20clicked%20submit%20button%205%20times%20at%20the%20completion%20of%20a%20Form%2C%20it%20will%20create%205%20same%20responses%20and%20mark%20it%20with%20continuous%20number%20such%20as%20ID%3A%201%2C%202%2C%203%2C%204%2C%205.%20Just%20like%20in%20database%2C%20when%20you%20mark%20the%20primary%20key%20column%20auto-increment.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1389038%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20for%20Excel%20results%20duplicating%20in%20Excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1389038%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F625613%22%20target%3D%22_blank%22%3E%40Sean_Shen%3C%2FA%3E%26nbsp%3Bwhat%20I%20am%20seeing%20has%20the%20same%20ID.%26nbsp%3B%20In%20your%20instance%2C%20you%20see%201%2C2%2C3%2C4%2C5.%26nbsp%3B%20I%20am%20getting%201%2C2%2C3%2C4%2C5%2C4%2C5%2C4%2C5%2C3%2C4%2C5%2C4%2C5%2C3%2C3%2C3%2C4%2C4%2C4%2C5%2C5%2C5%2C5.%26nbsp%3B%20No%20pattern%2C%20just%20random%20duplication.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20see%20where%20adding%20%22Only%20allow%20one%20response%22%20would%20stop%20your%20issue.%26nbsp%3B%20But%2C%20what%20I%20am%20seeing%20needs%20a%20validation%20rule%20in%20the%20database%20entry%20system.%26nbsp%3B%20The%20one%20thing%20I%20am%20seeing%20is%20it%20skipped%20entry%20%221185%22.%26nbsp%3B%20It%20seems%20to%20be%20trying%20to%20reload%20from%20there%20each%20time.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Deleted
Not applicable

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 puts the data in a row. This row then keeps duplicating itself without stop. This is happening on Excel online, and I can't seem to find a solution for this. Any help would be appreciated.

 

Thanks.

14 Replies
Highlighted
Was a solution ever found for this problem? I am also experiencing this issue, it just started happening.
Highlighted

Hi there, 

 

I am facing the exact same issue. Overnight, there are have been 1000+ duplicate entries created. Please, can anyone provide some guidance as to why this occurs and what can be done to resolve? 

Highlighted

I am having the same issue, but cannot find a solution. Please let me know if anyone has figured out why this is occurring. 

Highlighted
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.
Highlighted
Hello Mr Woan,

Kindly try checking the behavior on a newly created form and share the behavior with me
Highlighted

Rohit,

 

The problem persists for me after trying to start multiple forms from scratch. 

Highlighted

This issue still exists. There are a lot of duplicates in the results and I cannot bulk delete it in Microsoft Forms Online. Hence, the charts and graphics shown in Forms online are not accurate with lots of duplicated results.

Highlighted

Anyone found a resolution to this issue.  I have a Forms for Excel.  Randomly today, it started duplicating entries from Forms.

Highlighted

I created a test form and shared it with anyone can answer permission to myself. When I finished the form, by clicking the submit buttom multiple times before it redirected to the completed interface, the problem can be reproduced. For anyone in your orgnization permission, it actually has a choice that distincts the response that eliminates the duplicates. However, that option is not available to permission "anyone can answer". The problem is if I want a lot of people in the company to answer a form, having them login first will just stop them from answering the form.

In conclusion, I think it is a design issue and I guess Microsoft will not fix this or add a "one response from each user" option to "anyone can answer" permission in a short time.

 

Highlighted

@Sean_Shen 

 

Were the duplicate entries receiving the same ID number as well?  

 

What we were seeing was the same entry occurring multiple times throughout the day (i.e. I submit the form in the morning, 30 minutes later, 2 hours later, 2 hours 5 minutes later, etc. the same submission is entered again in the table).  This continued throughout the day.  Then, close to the end of the day, a new spreadsheet popped up in the SharePoint Excel file.  Now, this new file is doing the same thing.

Highlighted
This seems to be a bug in the application.
I have faced this issue as well.
The only work around for this problem is that delete those duplicate rows and make sure you delete them if that happens again.
We will have to follow this until MIcrosoft releases the fix for this error.


Regards.
Admin
https://www.o365cloudexperts.com/office-365-migration/
Highlighted

@RuskinF 

 

Agreed but sad.  The fix should be fairly easy "Do Not Allow Duplicates".  This is operating off what appears to be a basic database (assuming SQL compliant Db).  Opened it today and noticed it was replicating responses from April 27th.  It almost makes the application not usable.

Highlighted
No, the ID of each response is unique. Per say I clicked submit button 5 times at the completion of a Form, it will create 5 same responses and mark it with continuous number such as ID: 1, 2, 3, 4, 5. Just like in database, when you mark the primary key column auto-increment.
Highlighted

@Sean_Shen what I am seeing has the same ID.  In your instance, you see 1,2,3,4,5.  I am getting 1,2,3,4,5,4,5,4,5,3,4,5,4,5,3,3,3,4,4,4,5,5,5,5.  No pattern, just random duplication.

 

I see where adding "Only allow one response" would stop your issue.  But, what I am seeing needs a validation rule in the database entry system.  The one thing I am seeing is it skipped entry "1185".  It seems to be trying to reload from there each time.