Open in Excel - Results - Occasionally exporting to Document library of associated Group

%3CLINGO-SUB%20id%3D%22lingo-sub-1004096%22%20slang%3D%22en-US%22%3EOpen%20in%20Excel%20-%20Results%20-%20Occasionally%20exporting%20to%20Document%20library%20of%20associated%20Group%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1004096%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anyone%20experienced%20the%20SharePoint%20App%20account%20saving%20copies%20of%20the%20Forms%20survey%20results%20to%20the%20top%20level%20of%20the%20document%20library%20associated%20with%20the%20group%20that%20owns%20the%20Microsoft%20Forms%20form%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F156712i5A175023BE0B6F3D%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can't%20work%20out%20why%20this%20is%20happening%20and%20I%20am%20wondering%20if%20anyone%20else%20has%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20occurring%20on%20multiple%20sites%20and%20multiple%20forms.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1004096%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESurvey%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1005159%22%20slang%3D%22en-US%22%3ERe%3A%20Open%20in%20Excel%20-%20Results%20-%20Occasionally%20exporting%20to%20Document%20library%20of%20associated%20Group%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1005159%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F45795%22%20target%3D%22_blank%22%3E%40Andrew%20Silcock%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20think%20this%20is%20happening%20because%20you%20(or%20someone%20with%20access)%20is%20clicking%20the%3C%2FSPAN%3E%20'Open%20in%20Excel'%20button%20on%20the%20results%20tab%20of%20the%20form%20and%20excel%20is%20creating%20a%20new%20workbook%20each%20time%20the%20button%20is%20clicked.%20This%20usually%20happens%20if%20it%20created%20from%20OneDrive%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-ie%2Farticle%2FMicrosoft-Forms-and-Excel-workbooks-C61B5751-8128-4434-ABB0-246F5E2A3B01%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3E(Link%20to%20Article).%26nbsp%3B%3C%2FA%3E%20I%20haven't%20seen%20it%20happen%20in%20SharePoint%20though%20(but%20we%20don't%20create%20forms%20from%20SharePoint%20directly)%2C%20was%20it%20created%20in%20SharePoint%20as%20a%20'Forms%20for%20Excel'%20Document%3F%20Perhaps%20worth%20doing%20some%20testing%20there%20as%20it'll%20probably%20work%20in%20a%20similar%20way%20to%20OneDrive.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1006948%22%20slang%3D%22en-US%22%3ERe%3A%20Open%20in%20Excel%20-%20Results%20-%20Occasionally%20exporting%20to%20Document%20library%20of%20associated%20Group%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1006948%22%20slang%3D%22en-US%22%3EThanks%20for%20the%20reply%20Andy%2C%3CBR%20%2F%3E%3CBR%20%2F%3EIt%20doesn't%20seem%20to%20happen%20every%20time%2C%20which%20is%20what%20I%20can't%20wrap%20my%20head%20around.%20If%20the%20user%20wants%20to%20keep%20the%20Excel%20export%2C%20they'll%20save%20it%20using%20the%20save%20options%20from%20Excel%20Online.%3CBR%20%2F%3E%3CBR%20%2F%3EIt's%20not%20directly%20from%20SharePoint%20as%20such.%20The%20form%20is%20created%20against%20an%20O365%20Group%2C%20rather%20than%20an%20individual%20(group%20forms%20section%20in%20Forms)%20these%20results%20appear%20to%20be%20occasionally%20auto-saving%20to%20the%20root%20of%20the%20document%20library.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Regular Contributor

Hi all,

 

Has anyone experienced the SharePoint App account saving copies of the Forms survey results to the top level of the document library associated with the group that owns the Microsoft Forms form?

 

clipboard_image_0.png

 

I can't work out why this is happening and I am wondering if anyone else has?

 

This is occurring on multiple sites and multiple forms.

 

Thanks.

2 Replies

@Andrew Silcock 

Hi

I think this is happening because you (or someone with access) is clicking the 'Open in Excel' button on the results tab of the form and excel is creating a new workbook each time the button is clicked. This usually happens if it created from OneDrive (Link to Article).  I haven't seen it happen in SharePoint though (but we don't create forms from SharePoint directly), was it created in SharePoint as a 'Forms for Excel' Document? Perhaps worth doing some testing there as it'll probably work in a similar way to OneDrive.

Thanks for the reply Andy,

It doesn't seem to happen every time, which is what I can't wrap my head around. If the user wants to keep the Excel export, they'll save it using the save options from Excel Online.

It's not directly from SharePoint as such. The form is created against an O365 Group, rather than an individual (group forms section in Forms) these results appear to be occasionally auto-saving to the root of the document library.