This project has moved. For the latest updates, please go here.

Excel Data Table

Feb 26, 2012 at 9:55 PM


I'm trying to create an Excel Data Table (in Excel, it's normally under Data -> What-If Analysis -> Data Table).  I've searched through the current discussions and samples and didn't see anything too relevant.

I can create this by hand (just iterating over all the cells and creating a formula in each cell), but this defeats the purpose of making it easier for the user to change the formula.  If it's not possible, are there any other methods I might be able to use?