View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default two-way variable table keeps repeating same value

Try some quick diagnostics:

1. It could be calc mode. Press F9, does it now compute properly? The book
may intentionally or inadvertently been set to either Manual, or the
semi-auto calc mode called: Automatic except tables (the "tables" are the 1/2
way variable tables which are calc-intensive, hence this option is provided.
You press F9 if/when you want the tables to recalc, everything else is auto).

Check/correct the calc mode to Automatic via clicking:
Tools Options Calculation tab.

2. If (1) is not it, you've probably set it up wrongly. Re-do the DataTable
steps, try swapping the row/column inputs around, see whether this returns
the correct values.

3. The 1/2 way variable tables need to be created on the same sheet as the
base formula. That's the constraint I observed.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Damon G." wrote:
HELP!! I am building a two-way variable data table and everytime I press OK,
it just repeats the upper-most left column result which is the formula that
is referenced. PLEASE HELP!! I need to get this done.