Dynamic vs. Static Cell References

Cell references in assumption parameters are dynamic and are updated each time the workbook is recalculated. Dynamic cell referencing gives you more flexibility in setting up models because you can change an assumption’s distribution during a simulation.

Other types of cell references are static, such as the assumption name text box and correlation coefficients. These cell references are calculated once at the beginning of a simulation.