What If Analysis - 2 Variable Data Tables

[jalexdavis]

Hello, I have a workbook in which a summary tab includes several 2-variable data tables. In my attempt to evaluate multiple scenarios, I have copied the sheets that include these data tables. In the copied sheets, there is a single value output for each data table (i.e., different years, different exit multiples). In my attempt to resolve the issue, I have deleted the contents of the data tables and re-performed the data table analysis; however, the results are the same.

When I copy the worksheet, I am prompted with a notification regarding existing name ranges; however, when I open 'name manager' there is nothing in the field to review/delete.

Any advice is appreciated.

 

[shcon]

More accurate answer to your issue can be done if we can understand it more clearly. Please give us a sample workbook that may more describe about your requirement.