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