Home

How to copy a Forms for Excel to another site collection and keep it working?

%3CLINGO-SUB%20id%3D%22lingo-sub-1025625%22%20slang%3D%22en-US%22%3EHow%20to%20copy%20a%20Forms%20for%20Excel%20to%20another%20site%20collection%20and%20keep%20it%20working%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1025625%22%20slang%3D%22en-US%22%3E%3CP%3EUse%20case%3A%20we%20use%20the%20New-Forms%20for%20Excel%20in%20a%20modern%20Site%20Collection%20option%20to%20create%20a%20new%20Form.%20On%20completion%20(all%20questions%20%26amp%3B%20options%20defined)%20of%20the%20form%20we%20want%20to%20create%20a%20copy%20the%20Excel%20document%20to%20%3CSTRONG%3Eanother%3C%2FSTRONG%3E%20Site%20Collection%20and%20start%20using%20it%20there%20for%20another%20target%20audience.%20When%20opening%20the%20Excel%20in%20ExcelOnline%20the%20Insert-Forms-Preview%20(and%20other%20options%20are%20grey%20%26gt%3B%20see%202nd%20image)%2C%20though%20the%20Excel%20contains%20a%20worksheet%20'Form1'%20with%20all%20the%20columns%20as%20the%20original%20one.%20When%20opening%20the%20original%20in%20ExcelOnline%20all%20Insert-Forms%20options%20are%20available.%3C%2FP%3E%3CP%3EWhat's%20the%20best%20way%20to%20copy%20a%20Form%20for%20Excel%20to%20%3CU%3E%3CSTRONG%3Eanother%3C%2FSTRONG%3E%3C%2FU%3E%20Site%20Collection%3F%20(using%20the%20Forms%20UI%20you%20can%20also%20copy%20a%20Form%20but%20these%20are%20created%20in%20the%20same%20Site%20Collection-Library).%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20222px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F158439iF17E7AABA20D4A9A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Forms%20For%20Excel.png%22%20title%3D%22Forms%20For%20Excel.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3E1%20-%20Create%20Forms%20for%20Excel%20in%20Modern%20Site%20Collection%3C%2FSPAN%3E%3C%2FSPAN%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%20%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20376px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F158437i9F61A2F84A65304F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Forms-Copy-OpenExcelOnLine-InsertForms-OptionsNotAvailable.xlsx.png%22%20title%3D%22Forms-Copy-OpenExcelOnLine-InsertForms-OptionsNotAvailable.xlsx.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ECopy%20of%20Forms%20for%20Excel%20to%20other%20Modern%20Site%20Collection%20%26gt%3B%20Insert%20-Forms%20options%20are%20not%20available%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20305px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F158436i9AFA010B0007EA4E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Forms-Original-OpenExcelOnLine-InsertForms-OptionsAvailable.png%22%20title%3D%22Forms-Original-OpenExcelOnLine-InsertForms-OptionsAvailable.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EOrginal%20Forms%20for%20Excel%20%26gt%3B%20all%20Insert%20Forms%20options%20are%20available%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1025625%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Frequent Contributor

Use case: we use the New-Forms for Excel in a modern Site Collection option to create a new Form. On completion (all questions & options defined) of the form we want to create a copy the Excel document to another Site Collection and start using it there for another target audience. When opening the Excel in ExcelOnline the Insert-Forms-Preview (and other options are grey > see 2nd image), though the Excel contains a worksheet 'Form1' with all the columns as the original one. When opening the original in ExcelOnline all Insert-Forms options are available.

What's the best way to copy a Form for Excel to another Site Collection? (using the Forms UI you can also copy a Form but these are created in the same Site Collection-Library).

Forms For Excel.png1 - Create Forms for Excel in Modern Site Collection       Forms-Copy-OpenExcelOnLine-InsertForms-OptionsNotAvailable.xlsx.pngCopy of Forms for Excel to other Modern Site Collection > Insert -Forms options are not availableForms-Original-OpenExcelOnLine-InsertForms-OptionsAvailable.pngOrginal Forms for Excel > all Insert Forms options are available

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