P
PJM
I have a workbook for a company budget with an intentional circular reference (calculate a loan balance, then calculate the interest charge on that which changes the loan balance, etc.) I have changed the iteration to 10000 and the maximum change to 1 and it still will not calculate. I had the same file in Lotus (where the formulas worked) and converted it to Excel. My converted file works yet, when I renamed the file to save it into a new year budget file, the circular reference doesn't work. HELP PLEASE!!!