'Enter a supported XLSForm type...' message

109
2
Jump to solution
12-20-2021 10:52 AM
JayHodny
Regular Contributor

Good afternoon.  I am working with the latest version of Survey123 Connect and publishing to ArcGIS Enterprise 10.9.1.  I have created a new survey project from an existing survey, and then modified the XLSForm.  I have noticed that I cannot choose 'type' in the cells in column A of the XLSForm.  When I highlight a cell, I receive the message in the screen shot below and no drop-down list appears.  If I enter the type manually in a cell in column A, this seems to work, but it is not the desired behavior.  If I add a row, and highlight a cell (e.g., cell A4 in column A) there is no option to choose a type from the list.  I cannot figure out how to resolve the issue.  Any suggestions would be appreciated.  Thanks in advance, Jay

 

JayHodny_0-1640026285687.png

 

0 Kudos
1 Solution

Accepted Solutions
DougBrowning
MVP Notable Contributor

Most likely in the past you did a Ctrl C instead of paste values which brings validation with it and messes it all up.

See these posts for more info and fixes.

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-microsoft-excel/ba...

https://community.esri.com/t5/arcgis-survey123-blog/updated-xlsform-templates-for-survey123/ba-p/897...

 

View solution in original post

0 Kudos
2 Replies
DougBrowning
MVP Notable Contributor

Most likely in the past you did a Ctrl C instead of paste values which brings validation with it and messes it all up.

See these posts for more info and fixes.

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-microsoft-excel/ba...

https://community.esri.com/t5/arcgis-survey123-blog/updated-xlsform-templates-for-survey123/ba-p/897...

 

0 Kudos
JayHodny
Regular Contributor
Bingo! Cntrl-C/Cntrl-V - guilty. Thanks for the posts Doug.