Selected Answer
Hi geodav52,
I gave your file a look but could not find any obvious reason for this condition. So I did a Google search to see if I could find the cause. Of all the "fixes" posted, none of them were able to resolve your issue. Do other Excel files have this isuue? If so it is probably an Excel issue. If not, this file may be corrupted in some way. Did you install an Excel add-in before this issue arose? If so, try un-installing to see if that fixes it.
Then I noticed that in Payment #38 row (60) the ending balance was $0.00. So in the Extra Payment column I entered -250.00 to create a positive balance and PRESTO - all Payment #39 details showed up. Based on this, it must/might have to do with your " IF " formulas where the "if false" result is " "" ". I don't have the time to inspect the formulas but that might be a place to check.
You use O365 and I have 2016 so this is about all the assistance I can offer.
As a side note, you can make putting a check mark in column K (Confirmed) easier than using an image. Format the cells K26:K69 as "Wingdings2" and size 16. The type an upper case " P " and a checkmark will appear. Type an upper case " O " to get an X.
Update (20:30)
Had a few minutes to investigate further. For all rows below and all columns to the right of the table the issue does not exist - only within the bounds of the table. Also, rows 1 thru 22 do not experience this issue. It is only the range A23:J69 that has the issue.
Also, one at a time, I changed the " "" " at the end of the " IF " formulas to "No" but nothing changed. I then deleted all formulas in rows 60, 61, & 62 but the issue did not go away. So I am now leaning towards it has something to do with the way the table ($A$1:$J$69) is formatted.
Update (21:30)
I think I have found it. I decided to check what Conditional Formatting there might be in play. The first rule in the list has the font colour formatted as WHITE. I changed this to automatic and VOILA - everything appeared. This in conjuction with the $0.00 balance in Col " I " is what is causing the issue. So now you have to decide if you can live with this or want to change the CF rule. Also, you can make your CF rules shorter and easier to understand. Example: change your formula rule: "=IF(ROW(A23)>Last_Row,TRUE, FALSE)" to be just: "=ROW(A23)>Last_Row" (and the same for the other 2 rules). With this shorter version, if it returns a "True" result the formatting will be applied, if not it won't be.
If this solves things for you please mark my answer as selected. If not, maybe John will come up with a better solution.
Update 11/2/24
Even though I don't have any current need for a loan repayment table, I decided to have a go at creating one better than the one you have. The one I made is simpler and the only CF (yellow fill) is for the cells that need data input. Enjoy. Feel free to adapt/modify as you see fit to suit your needs.
Cheers :-)