Forum Discussion
Real time Microsoft Forms results in Excel Worksheet
Hi, I want to use Microsoft forms for an invoice in excel. I have made the invoice, which automatically collects data from the Excel table opened with Microsoft Forms, but when a new response has...
Hi
When you open the the Form in Microsoft Forms, you have 2 tabs at the top >> Click on the Responses Tab.
in the Upper right side there is an option saying: Open in Excel
If your excel file is saved in the clouds (oneDrive) then it updates to include new responses.
If you click on the elipses, there is an option to print the responses or delete them.
Hope that helps
Nabil Mourad
Hi,
I saved it on OneDrive, but when I fill in a new response, it isn't added to the existing Excel..
Do you know what the problem might be?
Thanks already for the help
I saved it on OneDrive, but when I fill in a new response, it isn't added to the existing Excel..
Do you know what the problem might be?
Thanks already for the help
Hi Suzanne
I assume you started creating your survey in Microsoft Forms and you try to view responses in Excel.
try to initially create your survey by using Forms in Excel Online: Insert Tab of the Ribbon >> Survey (or Form) and go from There.
Save the File in the clouds
Test responsesHope that helps
Nabil MouradHmm... why is this the case?
So you are saying Real Time update only works if Forms is created initially from Web Excel, but it will not work if I created the form first then "open in Excel"? This is so rigged... it supposed to be vice versal.
This is so annoying, I already created my forms and conditions, i have over 70 questions and now i have to redo everything again because Excel Web doesnt sync the data in real time at all =.= I tried your method, but I can't even import a template (will be REALLY nice they enable this option so i could just duplicate my form than to Recreate the whole form again).
My current solution is to keep doing "Sync all new responses to a new Workbook" which will just create multiple duplicates in my sharedrive........ This is so inefficient in the long run, to view live/new data, I have to manually create a new excel workbook and delete the old ones to prevent duplicates and wasting of space.- Circling back on this, JPClinc has the best solution: assign the form to a group (go into the Forms portal, click the ellipsis on the form when you hover over it, and click Move to Group. Once you do this, you can go back into the form, click Open in Excel, and it will bring up Excel Online with the form results in real-time!
My Excel online doesn't display a survey button in the insert tab. I have a paid 365 account. do I need to enable something. thanks
