topic Survey123 - Inserting rows inside excel sheet ~ keeps crashing!!! in ArcGIS Survey123 Questions

Survey123 - Inserting rows inside excel sheet ~ keeps crashing!!!

JordanMiller4 — Fri, 11 May 2018 13:04:46 GMT

I created an enterprise feature service and when I open the form's excel sheet and right click to insert a new row the sheet crashes. I've tried this about 5+ times and it keeps crashing. Does anyone know why this is happening?

Re: Survey123 - Inserting rows inside excel sheet ~ keeps crashing!!!

JamesTedrick — Fri, 11 May 2018 15:48:47 GMT

Hi Jordan,

While this forum isn't the best place to diagnose a MS Excel issue, I'm wondering if there is something particular to this Excel document or your MS Excel installation in general. Can you try to create a survey using one of the community samples and see if insertion of a row causes the crash as well?

Re: Survey123 - Inserting rows inside excel sheet ~ keeps crashing!!!

KatherinePadilla — Sat, 06 May 2023 03:43:00 GMT

I am having a similar issue. I did try to use the community survey and was able to add rows. All of my surveys are behaving this way and it is on every tab. The row just does not add or if insert copied row it will give me an error "This won't work because it would move cells in a table on your worksheet."

Any advice would be helpful. Thank you!!

Re: Survey123 - Inserting rows inside excel sheet ~ keeps crashing!!!

JonNott — Fri, 01 Mar 2024 19:41:54 GMT

I had the same issue and was able to resolve it with my Excel file by going to "Table Design" tab, and under "Table Name:", open "Resize Table". Then I updated the range of the table to a limited number of rows (included all columns in use). Mine was set default to the entirety of the rows within my columns (infinite number of rows). Once I set that to limited number of rows (I even included a number of extra rows to be safe), I could then insert new rows.