Pivot Tables and Scenario Manager

[robwong1]

I have a financial plan that depends on a pivot table to produce key metrics such as IRR and EBITDA. Can I use Scenario Manager to do sensitivities (changing product prices or costs), given there's a pivot table that needs to be refreshed before the IRR and EBITDA gets updated?

Or, should I give up and just write a Macro?

Thanks for any help.