Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TABLE function - not recalculating correctly
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... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data table is not updating correctly in excel 2003 | Excel Discussion (Misc queries) | |||
Pivot Table not sorting correctly | Charts and Charting in Excel | |||
EXCEL2000 trouble with SUM function recalculating on new data ent | Excel Worksheet Functions | |||
Using the NOW() function without it recalculating | Excel Worksheet Functions | |||
How to get pivot table Time field to appear correctly | Excel Worksheet Functions |