This problem has driven me nuts on more than one occassion, so I am documenting the solution here for reference. Maybe this will help you.
Problem: Enter formula into cell such as "=B2". After entering formula, instead of seeing the value of the B2 cell, you see "=B2".