Fixed drop-down fields are very helpful for shared/inter-company spreadsheets too. Highlight them in red until they're changed, then enforce the value via dropdown.