Hi,
Ive used data tables a fair amount in excel but given the time they take to recalculate (i have many in one s/sheet) im looking to create a macro rather which only runs when i choose to run it, but I've never really used macros before so am hoping for an easy example to get started.
Ive looked in the forum but cant seem to find an example of a simple macro which shows how to perform 'what-if' or sensitivity analysis on a variable calculated in a s/sheet - by assuming different values for a dependent variable also referenced in the s/sheet - so would appreciate any pointers.
Thank you.
p.s. im aware of the possibility of putting Calculation Options to 'Automatic except Data tables' but it is still very slow when one opens or saves the s/sheet and 'Manual' doesn't work for me as need rest of the worksheet to be dynamic.
Ive used data tables a fair amount in excel but given the time they take to recalculate (i have many in one s/sheet) im looking to create a macro rather which only runs when i choose to run it, but I've never really used macros before so am hoping for an easy example to get started.
Ive looked in the forum but cant seem to find an example of a simple macro which shows how to perform 'what-if' or sensitivity analysis on a variable calculated in a s/sheet - by assuming different values for a dependent variable also referenced in the s/sheet - so would appreciate any pointers.
Thank you.
p.s. im aware of the possibility of putting Calculation Options to 'Automatic except Data tables' but it is still very slow when one opens or saves the s/sheet and 'Manual' doesn't work for me as need rest of the worksheet to be dynamic.
