I have a bit complicated financial model used to forecast futures years' P&L performance, balance sheet and cash flow. It has circular calculation each year and each year's result will be used to calculate the following year.
It works but whenever I inadvertently input or delete any value that returns #Div/0! or #REF! then press F9 to calculate, all the out years calculation has error messages. Even I undo what I did, it seems the errors message are irreversible and the loaded model is screwed.![]()
Bookmarks