The circular reference comes from the “needed” or “oom_time” lifetap options in the DPS tab (B30). I don’t know where the problem comes from in Excel 2007, but you could work around like this :
- note the lifetap frequency in the D30 cell (should be something from 15 to 40 s).
- set the lifetap option to “custom”.- set the LT freq. (J9) to what you noted previously. You will get slightly differents values for dmg/hate and 0 dps for mp5
- make the changes you want
- when done, switch back to “oom_time” option.
Let me know if it does work for you.