"Allow editing directly in cells". I assume this got unchecked. This assumes you're using Excel 2007 or later. 2003 and earlier have a similar setting, but getting to it is slightly different.