Forum Discussion
Prakash Nimbalkar
Feb 20, 2018Copper Contributor
excel sheet protect using password ?
I want to collect the responses online from multiple people in the excel file, but I want to protect individual excel sheet with a password, is it possible? I want to have responses in excel sheets/...
Wyn Hopkins
Mar 10, 2018MVP
Hi Prakash,
Do you have Office 365? If so there's a "Forms" button on there that sounds perfect for your needs. You can create a survey really easily and the data gets saved in a table in the Excel file. The users can't see anyone else's results.
Prakash Nimbalkar
Mar 13, 2018Copper Contributor
Wyn Hopkins wrote:
Hi Prakash,
Do you have Office 365? If so there's a "Forms" button on there that sounds perfect for your needs. You can create a survey really easily and the data gets saved in a table in the Excel file. The users can't see anyone else's results.
Thank you Hopkins,
Yes, I know about forms but there was some conditional formatting in the excel- using different color codes. That is the reason I wanted to use excel.