Home

Protect only the previous data each time on excel file

%3CLINGO-SUB%20id%3D%22lingo-sub-692015%22%20slang%3D%22en-US%22%3EProtect%20only%20the%20previous%20data%20each%20time%20on%20excel%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-692015%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20excel%20to%20store%20data%20(Name%2FID%2FUnique%20number%2FDate%20of%20birth%20etc)%3C%2FP%3E%3CP%3EOther%20users%20have%20also%20access%20to%20this%20worksheet.%20Every%20day%20we%20input%20the%20data%20and%20then%20save.%20Is%20there%20any%20way%20to%20protect%20the%20previous%20data%20that%20have%20been%20saved%20from%20editing%3F%20And%20allow%20only%20new%20data%20entry..%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20any%20change%20on%20previous%20data%20would%20be%20done%20by%20authorized%20user%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20adavnce%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-692015%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
IoulietaLiatsou
Occasional Visitor

Hello,

 

I am using excel to store data (Name/ID/Unique number/Date of birth etc)

Other users have also access to this worksheet. Every day we input the data and then save. Is there any way to protect the previous data that have been saved from editing? And allow only new data entry.. 

And any change on previous data would be done by authorized user? 

 

Thank you in adavnce

 

 

Related Conversations