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 sev...
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.