Excel protected sheets not request password if opened from another device

%3CLINGO-SUB%20id%3D%22lingo-sub-3180217%22%20slang%3D%22en-US%22%3EExcel%20protected%20sheets%20not%20request%20password%20if%20opened%20from%20another%20device%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3180217%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20i%20need%20help%20for%20%3CSTRONG%3Eexcel%20protected%20sheets%20problem.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EUsing%20PC%2C%20latest%20excel%20version.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20a%20pendrive%20connected%20via%20usb%20to%20our%20router%2C%20we%20open%20this%20pendrive%20from%20different%20devices%20in%20our%20office.%3C%2FP%3E%3CP%3EI%20worked%20on%20this%20excel%20files%20and%20protected%20part%20of%20the%20sheets%20with%20a%20password%20so%20nobody%20can%20modify%20these%20cells.%3C%2FP%3E%3CP%3E%3CU%3EIf%20i%20reopen%20the%20file%20protected%20from%20the%20same%20device%20i%20worked%20on%2C%20the%20program%20ask%20me%20for%20password%20if%20i%20want%20to%20modify%20cells%2C%20but%20when%20i%20open%20the%20same%20files%20from%20another%20device%2C%20it%20is%20not%20needed%20password%2C%20just%20click%20on%20unprotect%20sheets%20and%20everything%20become%20modificable%20without%20even%20asking%20for%20a%20password%3C%2FU%3E%20%3CLI-EMOJI%20id%3D%22lia_face-with-open-mouth%22%20title%3D%22%3Aface_with_open_mouth%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3EHow%20is%20it%20possible%3F%20Am%20i%20not%20protecting%20the%20files%20when%20i%20set%20a%20password%20in%20%22protect%20sheet%22%3F%20Why%20the%20thing%20changes%20if%20i%20use%20an%20other%20device%20but%20open%20the%20SAME%20file%20on%20the%20SAME%20pendrive%20accessing%20via%20router%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20help%20me%3F%20I%20want%20to%20protect%20these%20files%20more%20effectively%20from%20modify%20from%20other%20users%20accessing%20it%20by%20multiple%20device%2C%20but%20i%20need%20they%20can%20see%20the%20data%20and%20open%20the%20files.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20did%20not%20find%20other%20discussion%20on%20this%20issue%2C%20but%20i%20am%20not%20writing%20in%20my%20mother%20language%2C%20sorry%20in%20advance%20if%20i%20searched%20bad.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3180217%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi, i need help for excel protected sheets problem.

Using PC, latest excel version.

 

We have a pendrive connected via usb to our router, we open this pendrive from different devices in our office.

I worked on this excel files and protected part of the sheets with a password so nobody can modify these cells.

If i reopen the file protected from the same device i worked on, the program ask me for password if i want to modify cells, but when i open the same files from another device, it is not needed password, just click on unprotect sheets and everything become modificable without even asking for a password

How is it possible? Am i not protecting the files when i set a password in "protect sheet"? Why the thing changes if i use an other device but open the SAME file on the SAME pendrive accessing via router?

 

Can you help me? I want to protect these files more effectively from modify from other users accessing it by multiple device, but i need they can see the data and open the files.

 

I did not find other discussion on this issue, but i am not writing in my mother language, sorry in advance if i searched bad.

0 Replies