Forum Discussion
Solved
Data/What If/Data Table Problems
Is anyone familiar with problems using the Data/What If/Data_Table function? I have used it in the past but now it doesn't work. It returns only the original results for all variables. I've tried several different models that I've used in the past and even the sample contained in the Excel Help file (sample attached), none of them work. -Thanks
John, it works if you press Formula->Calculate Sheet in the ribbon, checked on your file. For automatic calculation change in Excel options in Formulas->Calculation options->Workbook calculations the "Automatic except the data tables" (which is by default) on "Automatic"
John, it works if you press Formula->Calculate Sheet in the ribbon, checked on your file. For automatic calculation change in Excel options in Formulas->Calculation options->Workbook calculations the "Automatic except the data tables" (which is by default) on "Automatic"
Thank you so much. I thought I checked that in the Options page, but hadn't.
