Excel Model Problem?

Question

I'm building a financial model on microsoft excel. The problem is the model isn't flexible. For instance, cells doesn't automatically adjust when I change other inputs( variables). It's tedious pushing F2to make necessary adjustments... Any suggestions?

Thanks!

Answer 1

If you want Excel to recalculate all the formulas continually, you can change between automatic and manual calculation for all the formulas in an Excel workbook by clicking the circular "Microsoft Office Button" then clicking on Excel Options and then Formulas. Now set "Calculation Options" as "Automatic. Set it as Automatic except for data tables" if you want to exclude the data tables from the recalculation. Set it to "Manual" if you want to calculate the formulas only when you give the command. Click "OK" in order to save your desired settings.