Thanks Niek.. looks like I have hit likely hit the dependency limit... thanks
for the help!

"Niek Otten" wrote:

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?