Re: Linking form responses using Power Query

agwalsh I learnt from the section https://www.howtoexcel.org/general/microsoft-forms/, linked as the text. It was clueless how to form a live response data collection until I came across this article. Before starting any edit, please Open in Desktop App. I managed to create an excel data file with queries on SharePoint link with my form responses at the first tab. Using Power Query as a second tab for table calculation and total score evaluation. After completing all the data analysis, remember to autosave so it will sync the data back SharePoint. Hope this helps.