Home

Forms to Excel Output After Editing

%3CLINGO-SUB%20id%3D%22lingo-sub-708418%22%20slang%3D%22en-US%22%3EForms%20to%20Excel%20Output%20After%20Editing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-708418%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20form%20that%20outputs%20to%20a%20workbook%20where%20data%20is%20then%20run.%20I%20needed%20to%20add%20additional%20questions%20to%20the%20form%20and%20now%20the%20new%20responses%20will%20not%20show%20up%20in%20the%20workbook.%20When%20editing%20the%20form%20itself%2C%20it%20indicates%20that%20all%20of%20the%20responses%20still%20exist%2C%20but%20when%20I%20click%20on%20the%20%22open%20in%20Excel%22%20button%2C%20the%20responses%20submitted%20after%20the%20form%20changes%20are%20not%20there.%20I%20am%20not%20sure%20if%20this%20is%20relevant%20but%20I%20also%20notice%20when%20I'm%20on%20the%20workbook%20it%20says%20%22SharePoint%20App%20is%20also%20editing.%22%20Does%20anyone%20know%20how%20to%20sync%20my%20answers%20with%20the%20current%20workbook%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-708418%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-708572%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20to%20Excel%20Output%20After%20Editing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-708572%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F363242%22%20target%3D%22_blank%22%3E%40kumar430%3C%2FA%3E%26nbsp%3B%2C%20in%20general%20it%20shall%20work.%26nbsp%3B%3CSPAN%3E%22SharePoint%20App%20is%20also%20editing%22%20means%20what%20Excel%20file%20is%20synced%20with%20Forms.%20After%20you%20edit%20the%20form%2C%20app%20shall%20add%20accordingly%20columns%20to%20the%20table%20in%20Excel%20file%20(do%20you%20have%20them%3F).%20Thus%20by%20default%20it%20shall%20work.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EI%20have%20no%20answer%20what%20could%20be%20wrong%2C%20perhaps%20it's%20better%20to%20ask%20Forms%20community%20here.%20That's%20more%20on%20their%2C%20not%20Excel%20site.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-708618%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20to%20Excel%20Output%20After%20Editing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-708618%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThe%20new%20columns%20were%20not%20created%20in%20the%20excel%20automatically.%20Do%20I%20need%20to%20add%20the%20columns%20myself%20in%20order%20for%20the%20new%20questions%20to%20register%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-708896%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20to%20Excel%20Output%20After%20Editing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-708896%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F363242%22%20target%3D%22_blank%22%3E%40kumar430%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20try%2C%20but%20I'm%20not%20sure%20that%20helps.%20Normally%20you%20may%20add%20columns%20to%20the%20table%20even%20if%20they%20are%20not%20part%20of%20the%20form.%20For%20example%2C%20make%20some%20calculations%20on%20the%20answers%20columns.%3C%2FP%3E%3C%2FLINGO-BODY%3E
kumar430
New Contributor

I have a form that outputs to a workbook where data is then run. I needed to add additional questions to the form and now the new responses will not show up in the workbook. When editing the form itself, it indicates that all of the responses still exist, but when I click on the "open in Excel" button, the responses submitted after the form changes are not there. I am not sure if this is relevant but I also notice when I'm on the workbook it says "SharePoint App is also editing." Does anyone know how to sync my answers with the current workbook?

3 Replies
Highlighted

@kumar430 , in general it shall work. "SharePoint App is also editing" means what Excel file is synced with Forms. After you edit the form, app shall add accordingly columns to the table in Excel file (do you have them?). Thus by default it shall work.

 

I have no answer what could be wrong, perhaps it's better to ask Forms community here. That's more on their, not Excel site.

 

@Sergei Baklan The new columns were not created in the excel automatically. Do I need to add the columns myself in order for the new questions to register?

@kumar430 

 

You may try, but I'm not sure that helps. Normally you may add columns to the table even if they are not part of the form. For example, make some calculations on the answers columns.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies