Question: what is the difference between datatable and scenario manager?
Answer: A Data Table works with only one or two variables, but it can accept many different values for those variables. A Scenario can have multiple variables, but it can only accommodate up to 32 values. ... The Solver add-in is similar to Goal Seek, but it can accommodate more variables.