I had luck sharing it as duplicate. Click Share (top right), copy the Share as a Template link and open, hit Duplicate and it creates a copy in your Forms. But other than that it looks like a one way street.
tried your method but the duplicated form has missing questions. I had 29 questions in the original form. After duplicating it, i'm only left with 14 questions =(.
It's excelent. That worked. Thank you! But I think we can't be in a hurry to go to "My forms", before the process really stop (after hit "Duplicate" bottom).
@gustavotrigo info in forms is held in excel format so you would need to use the download to Excel and treat it as a spreadsheet. Keeping the two together is convoluted.
I know where I would experiment but haven't tried it: -
Download results to desktop (Form >Responses>Open in excel)
Open spreadsheet with ONLINE version of Excel (in the cloud)
In the spreadsheet go insert > forms > new form
Then you will have to create a new form matching the titles and order as shown on the spreadsheet headings,
The form (hopefully) should then be tied to the results in the spreadsheet.
@TimGJ Now I've actually had time to think about it
On the copy of the forms go to Responses then Open in excel You have a spreadsheet with all the correct columns just no information
On the original form
Do the same (Responses> Open in Excel) then copy/paste to the new spreadsheet - what I don't know is if the linking table from the spreadsheet to the form will automatically be created - you will need to experiment.
Use the headings at the top of the spreadsheet as the questions on the form, in that order, so the two are the same. therefore, hopefully the answers to the questions will appear in the correct columns on the spreadsheet. Haven't tried it yet but the two need to align or the data goes in the wrong place - problem is somebody with an encyclopaedic level of knowledge at Microsoft really needs to tell us what to do and what the limitations are.
