The first step in enabling iterative calculations in Excel is to select File in the top left hand of the ribbon. In Excel 2016 Excel 2013 and Excel 2010 go to File Options Formulas and select the Enable iterative calculation. Go to File Options.
Cell A1 contains the value that your DDE program writes.
Enter the target value you want to achieve to value. In most institutionaI-quality financial modeIs in Excel there are calculations that need to be circular. In the Calculation options section select the Enable iterative calculation check box. If youre using Excel for Mac click the Excel menu and then click Preferences Calculation.