+ Reply to Thread
Results 1 to 2 of 2

Irreversible Errors in model with circular calculation

  1. #1
    Registered User
    Join Date
    02-27-2010
    Location
    Philadelphia, US
    MS-Off Ver
    Microsoft 365 ProPlus
    Posts
    2

    Unhappy Irreversible Errors in model with circular calculation

    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.

  2. #2
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191

    Re: Irreversible Errors in model with circular calculation

    I guess my first question is why you built it to allow or even need circular calculation. It's very difficult to get the results right even when allowing it because Excel only goes through x many iterations. Do you have the option for allowing circular references checked or unchecked? I assume checked, but it doesn't hurt to ask.

    Also, would it be possible to post the workbook with dummy data?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1