Created a form in forms.office, but this means that when you click Open in Excel it downloads the results file rather than opening it in Sharepoint online which is what happens when OneDrive for business is Used. Is there any way to convert the form so that the results file opens online?
Have to admit I don't even know how this form was created in "forms.office" rather than OneDrive...Why can't MS even use proper titles for functions, users might have some idea what they are doing!!
PS: Forms has so much potential but it is a million miles behind Google Sheets, and Microsoft's response to suggestions and feature seems to be to put everything on the long finger i.e. suggestions are made by users, but they are never implemented!!