Language Column not appearing when creating forms via SharePoint Menu New->Forms for Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-3107558%22%20slang%3D%22en-US%22%3ELanguage%20Column%20not%20appearing%20when%20creating%20forms%20via%20SharePoint%20Menu%20New-%26gt%3BForms%20for%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3107558%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20creating%20a%20multilingual%20form%20via%20the%20sharepoint%20menu%20(New-%26gt%3BForms%20for%20Excel)%20or%20from%20within%20an%20excel%20file%20in%20Sharepoint%2C%20the%20language%20column%20does%20not%20appear%20in%20the%20underlying%20(connected)%20Excel%20file.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EHowever%20I%20did%20find%20a%20workaround.%20If%20you%20Sync%20all%20responses%20to%20a%20new%20workbook%2C%20the%20language%20column%20now%20appears%20in%20the%20new%20file%20!%3CBR%20%2F%3E%3CBR%20%2F%3ENOTE%20%3A%20This%20issue%20is%20not%20experienced%20if%20you%20create%20the%20Forms%20via%20Forms%20and%20the%20excel%20file%20is%20'disconnected'.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MartinLavoie_0-1643835097848.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F344804i7B0D4D6069DD4BB9%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22MartinLavoie_0-1643835097848.png%22%20alt%3D%22MartinLavoie_0-1643835097848.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3107558%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eforms%20multilingual%20language_column%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

When creating a multilingual form via the sharepoint menu (New->Forms for Excel) or from within an excel file in Sharepoint, the language column does not appear in the underlying (connected) Excel file. 

However I did find a workaround. If you Sync all responses to a new workbook, the language column now appears in the new file !

NOTE : This issue is not experienced if you create the Forms via Forms and the excel file is 'disconnected'.

MartinLavoie_0-1643835097848.png

 

0 Replies