using Table function in array formula

[gp2012]

Hi,

I inherited an Excel with a scenario table (one variable by other variable) and a sensitivity table that comes with it. The sensitivity table seems to be created via a formula that looks like {=table(X variable, Y variable)}. When I try to copy the sensitivity table to a new sheet it only copies the values. When I try to copy the table by re-writing the exact formula I get the error that table isn't a function and it won't let me do it.

Any idea on what I can do to replicate the sensitivity data table?

 

[Dave Patton]

You may be referring to a feature of Excel

look in Data | What-if-Analysis | Data Table

or search for information on using a Data Table