Hi all... I have a spreadsheet that is not updating formulas when changes are
made. The options are set correctly to autocalc, and I've read all of the
advice here about how Excel gets it's settings from the first excel file
opened in a session.

I've closed Excel, reopened. Open a blank worksheet, verified that it's set
to auto calc. Then I open the troubled file and it has the 'calculate' in
the bottom left-hand side. If I go in to options, it's still checked at
Auto, even though it isn't working.

Ideas?