Forum Discussion
why is excel changing a formula in a locked and protected cell
I have quite a complex spreadsheet for use in my hobby of PBM - the spreadsheet includes an order form for players to submit instructions but with 1 player i am experiencing problems that I cannot fa...
It’s likely a version or sync issue. Ask the user to open the file in Excel Desktop (not web), turn off AutoSave, and ensure formulas aren’t auto-updating. Re-save as .xlsx this usually stops protected cells from changing.