change from one excel worksheet to another by double clicking in cell

%3CLINGO-SUB%20id%3D%22lingo-sub-1746171%22%20slang%3D%22en-US%22%3Echange%20from%20one%20excel%20worksheet%20to%20another%20by%20double%20clicking%20in%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1746171%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20excel%20worksheet%20which%20I%20update%20data%20in%20every%20week.%20My%20employees%20have%20an%20identical%20excel%20worksheet%20which%20copies%20the%20data%20from%20my%20worksheet%20for%20their%20information.%20Their%20worksheet%20is%20protected%20so%20they%20cannot%20change%20the%20data%20or%20the%20structure%2C%20but%20if%20they%20double%20click%20in%20a%20cell%20they%20will%20be%20sent%20to%20my%20worksheet%20where%20they%20can%20change%20the%20parent%20document.%20Can%20I%20fix%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1746171%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1746532%22%20slang%3D%22en-US%22%3ERe%3A%20change%20from%20one%20excel%20worksheet%20to%20another%20by%20double%20clicking%20in%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1746532%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F820729%22%20target%3D%22_blank%22%3E%40tchildte1%3C%2FA%3E%2C%3C%2FP%3E%3CP%3EAs%20far%20as%20I%20know%2C%20you%20need%20to%20check%20%22Allow%20editing%20directly%20in%20cells%22.%20This%20will%20have%20to%20be%20done%20in%20your%20employees%20system.%3C%2FP%3E%3CP%3EExcel%20Options%26gt%3BAdvanced%26gt%3BEditing%20options...%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Bennadeau_0-1601918883944.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F224230i513DABC20272203D%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Bennadeau_0-1601918883944.png%22%20alt%3D%22Bennadeau_0-1601918883944.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1746869%22%20slang%3D%22en-US%22%3ERe%3A%20change%20from%20one%20excel%20worksheet%20to%20another%20by%20double%20clicking%20in%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1746869%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F703724%22%20target%3D%22_blank%22%3E%40Bennadeau%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20just%20it.%20I%20don't%20want%20them%20to%20be%20able%20to%20edit%20just%20read.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have an excel worksheet which I update data in every week. My employees have an identical excel worksheet which copies the data from my worksheet for their information. Their worksheet is protected so they cannot change the data or the structure, but if they double click in a cell they will be sent to my worksheet where they can change the parent document. Can I fix this?

2 Replies

Hi @tchildte1,

As far as I know, you need to check "Allow editing directly in cells". This will have to be done in your employees system.

Excel Options>Advanced>Editing options...

Bennadeau_0-1601918883944.png

 

 

@Bennadeau 

That just it. I don't want them to be able to edit just read.