Select to view content in your preferred language

S123 Connect duplicating row to survey sheet when I add it to choices sheet

484
2
Jump to solution
11-05-2024 06:44 AM
SavannahThomson1
Emerging Contributor

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. 

0 Kudos
1 Solution

Accepted Solutions
abureaux
MVP Frequent Contributor

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.

abureaux_0-1730844974931.png

Ensure you have only ONE tab selected and try again.

 

View solution in original post

2 Replies
ChristopherCounsell
MVP Frequent Contributor

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.

0 Kudos
abureaux
MVP Frequent Contributor

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.

abureaux_0-1730844974931.png

Ensure you have only ONE tab selected and try again.