Yes the table is A1:H2. One of the properties of a table is that you can delete all the rows but the table "remembers" any formulae that have been present. When a new first row is entered the formulae are still present. Yes if you choose to delete sheet rows the table is also deleted. I did say delete a table row. So inserting a new row should re-establish the formulae that existed before the deletion. It does for the formula format in colums G & H but it gets the formula in column F wrong. The issue is why does this particular format fail and also that users should be aware that this is going to happen. To answer your unasked question about why I would want to delete the last remaining row in a table and then start to fill it up again; well I have on several occasions found it a useful way of reusing a table and its formulae for a series of different data just as one might do with a table in a database. Database tables can also contain fields (columns) which are based on numerical relationships between other fields in the same table. I guess none of this gets us any closer to understanding why there is this apparent fault but in the course of our debate you have given me some new info which I appreciate.