Allow Add-ins to create Excel Data Tables

Allow Add-ins to create Excel Data Tables
0

Upvotes

Upvote

 Jun 30 2024
0 Comments 
New

It would be great if I could have users indicate inputs and the output value and then we create a fully functioning Sensitivity Analysis matrix for them (under What-If Analysis). The end goal is to create these on a hidden sheet, grab the values, and delete it, so the table would be temporary and part of a workflow in our add-in using the sensitivity analysis values without having persistent tables and without requiring much from users.