Mortgage Payment Table

New Contributor

Formulas copied and pasted into new cells do not yield results at all (see cell E8):


or are not calculating automatically based upon what should be the new reference cells unless the cursor is put at the end of the formula in the formula bar and one hits enter

2 Replies


Activate the Formulas tab of the ribbon.

Make sure that Calculation Options in the Calculation group is set to Automatic.


Also make sure that there is no message "Circular References" in the status bar at the bottom of the Excel window.

best response confirmed by rafish1 (New Contributor)

Excellent @Hans Vogelaar 

Thank you so much!