View Excel data like a Form (read-only) but within Teams
February 12, 2020 10:40 AM Subscribe
I have a Microsoft Team for my large research team that features a very wide Excel spreadsheet containing details about each of our study subjects. As the "Keeper of the Data," I've locked the spreadsheet down so that it is Read-Only. How can I make a Form view of the rows contained in this spreadsheet so that my team members can quickly browse for the study subject in question, and see data presented in an easy-to-read view? Challenge: I want this to be viewable from within our Team. Form view (via regular Excel) doesn't appear to work in the Team version of Excel.