Forum Discussion

Copper Contributor

Oct 05, 2020

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

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

excel

Bennadeau

Iron Contributor

Oct 05, 2020

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

tchildte1

Copper Contributor

Oct 05, 2020

Bennadeau

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