Forum Discussion
Need solution for collecting travelling datas
Hello there! I 'm collecting 10 colleague's travelling datas every month and I need a foolproof solutions for this. We have a form with personal datas/car datas, and they need to fill the dat...
You can restrict access to workbooks with Information Rights Management (IRM) in Excel.
You can assign different access levels for each user, such as read-only or edit permissions.
You need to have a Microsoft 365 subscription that includes IRM features.
Another option is to save the sheets that you want to restrict as a separate workbook and share it with specific users on SharePoint online. You can also hide or unhide sheets in Excel, but this is not a secure way to protect data.