Gary,

Generally, if you insert rows into a table, you will mess up the formula
references. You can easily solve this by copying down the formula for that
column from a row that is above your insertion point, all the way down to
the end of your table.

One way around this is to not use formulas in your table, but to use the
table a the source for a pivot table. In those cases, insertion into the
table may actually be preferred.

HTH,
Bernie
MS Excel MVP


"Gary Huston" wrote in message
...
I am using a ledger for simple accounts, Date, Name, Service, Amount
and Total.
The far right column keeps a running total. I have however omitted
some data and am trying to add rows in various places in date order.
I can insert the rows no problem, however, the final right hand cell
remains blank and will not update the total.
I have tried the format painter which works for all cells but the
last, the format bar is greyed out along with anything else I thought
I could use to solve the problem.
I have tried adding the data on the last row and dragging it up to
where I want it but as soon as I move it even one place the final cell
goes blank again...
I'm sure it's something simple and that I have overcome this problem
before but this time it's driving me nuts!