Mortgage Payment Table

Copper 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

3 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 (Copper Contributor)

Excellent @Hans Vogelaar 

Thank you so much!

I know this is an old thread, but I thought I could share my 2 cents to help (if someone still needs help here). Have you checked to make sure the cell formatting is correct? Sometimes that can cause issues with formulas. Also, have you heard of the Florida closing cost calculator?