My survey is close to being complete but for whatever reason when I try to add a row to the choices sheet, it is being duplicated to the survey sheet. There are also instances where the name field in the survey sheet is replacing the name field in the choices sheet. You can see in the screenshots provided I add the P1 sensor to the choices sheet -> hit save -> it appears in the survey sheet. You can also see how that "comments" name is being added to the choices sheet from the survey sheet. Please help.
Solved! Go to Solution.
100% an Excel "issue" (technically "working as intended").
@SavannahThomson1 If I had to guess, you have multiple tabs selected (see screen shot below). In Excel, when you select multiple tabs, your changes are reflected on all those selected tabs.
Ensure you have only ONE tab selected and try again.
I've seen a lot of surveys and never seen anything like this before. It looks like an Excel issue, as Connect reads the XLS file and I don't believe would have permissions to write to the file after you hit save.
Can you provide the xlsx file?
What version is the xlsform template and what version of survey123 connect are you using?
I would recommend just updating to the latest survey123 connect version, creating a new survey (fresh excel file) and then remake the survey in the new file. You can copy the xlsx file back into the exisiting survey folder if you've already published.
When copy pasting values into the new xlsx file, right-click and select 'paste values only'. This presents the Excel formatting from being overwritten. I'd also paste only the second row and down and ensure that the columns are in alignment. If using a newer template copy-pasting blind might put things in the wrong column.
100% an Excel "issue" (technically "working as intended").
@SavannahThomson1 If I had to guess, you have multiple tabs selected (see screen shot below). In Excel, when you select multiple tabs, your changes are reflected on all those selected tabs.
Ensure you have only ONE tab selected and try again.