Lock cells by allow computed values
I have EXCEL sheets with lock and unlock cells so my users can only edit where they are supposed to. However, I have cells that are calculated and I want then locked as well. It appears that lock calculated cells NO LONGER compute. I need to leave them unlocked and therefore vulnerable to users to mess with it. Why does locking need to affect calculated fields?