Check this list:
http://xldynamic.com/source/xld.xlFAQ0024.html
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"LR" wrote in message ...
| 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?