TABLE function - not recalculating correctly

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Tools>Options>Calculation tab, Calculation is set to "Automatic except tables"

By "tables" do you mean tables like in Data>Tables?

Otherwise, check this list:

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

especially "corrupted dependency tree"

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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...
 
Yes, "Data>Table..."

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
 
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?
 
Does anyone of you use Excel2007?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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, "Data>Table..."
| >
| > 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:
| > >
| > > Tools>Options>Calculation tab, Calculation is set to "Automatic except tables"
| > >
| > > By "tables" do you mean tables like in Data>Tables?
| > >
| > > Otherwise, check this list:
| > >
| > > http://xldynamic.com/source/xld.xlFAQ0024.html
| > >
| > > especially "corrupted dependency tree"
| > >
| > > --
| > > Kind regards,
| > >
| > > Niek Otten
| > > Microsoft MVP - Excel
| > >
| > > |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...
| > >
| > >
| > >
 
Niek Otten said:
Does anyone of you use Excel2007?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel
Click to expand...
Yes; I do use 2007, and that is my complaint -- what I was able to do in
2003, I am no longer able to do in 2007.
 
OK.
I'm not sure it is the same issue (haven't had time yet to figure out), but there was a discussion in one of the groups about
tables in 2007, where the final conclusion was: "it's a bug".
Google for a post by "frustrated Professor <frustrated (e-mail address removed)>" and check whether it is the same
issue.

Post again in this same thread if it's not or if you have additional questions

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|
|
| "Niek Otten" wrote:
|
| > Does anyone of you use Excel2007?
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| Yes; I do use 2007, and that is my complaint -- what I was able to do in
| 2003, I am no longer able to do in 2007.
 
It is EXACTLY this problem! I, too, am a frustrated professor as I both use
this feature in my own research and I instruct/require my students to do so
as well. everything worked in 2003 and earlier versions.

Ed
 
Back
Top