May 01 2020 12:38 AM
May 01 2020 07:52 PM
Hi @Paul_Castelino;
If you are collaborating with Excel file then use can try JavaScripts for not allowing the users to insert information and if you are collecting the information then I would recommend you using Microsoft Forms. Once the user made the entries cannot be amended. You can connect your forms using Microsoft PowerAutomate to directly get the forms information into Excel workbook each time the records are added.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more