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.
Is there a better method to upgrade a survey to the latest template?