I'm having exactly the same problem and cannot find the solution or a
workaround. Data tables I created and used in earlier versions of Excel no
longer work properly for me.

Any help out there?

"Jacob" wrote:

Yes, "DataTable..."

Automatic recalculation is set to "Automatic", NOT "Automatic except tables".

I tried the Ctrl-Alt-Shift-F9 and Ctrl-Alt-F9 methods - no fix :-(

Any other ideas? Again - the data table is being contructed based on the
results of another data table.... it works sometimes, but not consistently.

Thanks,

Jacob

"Niek Otten" wrote:

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...