topic Re: copying rows sometimes loses the drop down menu in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/copying-rows-sometimes-loses-the-drop-down-menu/m-p/815919#M14558 <HTML><HEAD></HEAD><BODY><P>Hi Mike,</P><P></P><P>When you copy the values over from your old survey xlsx template, make sure you copy and paste them into the new template as values only (use the advanced paste menu). This will ensure the formatting is not copied over from the old template, and will keep the new formatting and drop downs in new template.</P><P></P><P>Regards,</P><P>Phil.</P></BODY></HTML> Tue, 27 Feb 2018 23:59:34 GMT Anonymous User 2018-02-27T23:59:34Z copying rows sometimes loses the drop down menu https://community.esri.com/t5/arcgis-survey123-questions/copying-rows-sometimes-loses-the-drop-down-menu/m-p/815918#M14557 <HTML><HEAD></HEAD><BODY><P>Sometimes when I copy rows in the Excel spreadsheet while working on a survey the drop down menu doesn't work anymore in the new row I've created. This happened today when I wanted to take advantage of the newest template to "upgrade" a survey I created over a year ago. All of the drop down menus in the rows I copied from the original sheet into the new sheet don't work but blank rows work. I could go though and fix them all one by one but I think there should be a easier way.</P><P></P><P>Is there a better method to upgrade a survey to the latest template?</P></BODY></HTML> Tue, 27 Feb 2018 23:40:35 GMT https://community.esri.com/t5/arcgis-survey123-questions/copying-rows-sometimes-loses-the-drop-down-menu/m-p/815918#M14557 MikeOnzay 2018-02-27T23:40:35Z Re: copying rows sometimes loses the drop down menu https://community.esri.com/t5/arcgis-survey123-questions/copying-rows-sometimes-loses-the-drop-down-menu/m-p/815919#M14558 <HTML><HEAD></HEAD><BODY><P>Hi Mike,</P><P></P><P>When you copy the values over from your old survey xlsx template, make sure you copy and paste them into the new template as values only (use the advanced paste menu). This will ensure the formatting is not copied over from the old template, and will keep the new formatting and drop downs in new template.</P><P></P><P>Regards,</P><P>Phil.</P></BODY></HTML> Tue, 27 Feb 2018 23:59:34 GMT https://community.esri.com/t5/arcgis-survey123-questions/copying-rows-sometimes-loses-the-drop-down-menu/m-p/815919#M14558 Anonymous User 2018-02-27T23:59:34Z