Maybe:

ToolsOptionsCalculation tab, Calculation is set to "Automatic except tables"

By "tables" do you mean tables like in DataTables?

Otherwise, check this list:

http://xldynamic.com/source/xld.xlFAQ0024.html

especially "corrupted dependency tree"

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Jacob" wrote in message ...
|I have a complex data table that is calculating based on the results of
| another data table. The first time I enter it, the dependent data table
| calculates just fine. After one worksheet recalculation, though, the data
| table loses its dynamic-ness - it ends up choosing one value and sticking at
| it. I'm trying to develop the probability of an event based on amalgamated
| probabilities of other events, all derived off a RAND()call with some rules
| (if statements), and so I need to run like 1000 trials.
|
| Anybody know of this issue, where data tables "stick" on one value?
|
| I'm pretty certain I put in the data table correctly...