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
Highlighted
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
Highlighted

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

 

 

Highlighted

@Bennadeau 

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