Forum Discussion
excel sheet protect using password ?
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.
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.
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.
Ah, OK then Prakash Nimbalkar.
Unfortunately there is currently no way to do this in Excel Online.
With Excel desktop you can write VBA to protect and hide sheets based on passwords but
a) Only 1 user can enter data at a time
b) as Stefan Holmes mentions it's nearly impossible to make worksheets 100% secure
Sending out independent templates and then using Power Query to consolidate them is my current process.
