Do you know how to make the online Excel file read-only for non-admins while still giving them to rights to fill in the form and save it so it gets saved in the Excel? When making it read-only now, when the users fill in the form it doesn't get added to the Excel. Thanks!
Hi ThomasDavid, I don't think that's a posibility. On the one hand you don't want them to edit, and on the other you actually need them to. A posibility could be to hide the file and only show the file in a administrator overview or Power BI report. Thanks for sharing your thoughts.
Thanks for sharing Erik. My team stumbled into this a few months back...GAME CHANGER!!!!
Thanks Rich, it really is 👍🏻
Do you know how to make the online Excel file read-only for non-admins while still giving them to rights to fill in the form and save it so it gets saved in the Excel?
When making it read-only now, when the users fill in the form it doesn't get added to the Excel.
Thanks!
Hi ThomasDavid, I don't think that's a posibility. On the one hand you don't want them to edit, and on the other you actually need them to.
A posibility could be to hide the file and only show the file in a administrator overview or Power BI report.
Thanks for sharing your thoughts.