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!

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!

On 14 Nov, 18:40, "Bernie Deitrick" <deitbe @ consumer dot org wrote:
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!

I would love to copy the formula from above, the problem is I can't
access it, I can't get into formulas, everything is greyed out and it
says formulas are not used in ledgers.

Gary,

What version of Excel are you using? And, is the sheet protected?

Bernie


"Gary Huston" wrote in message
...
On 14 Nov, 18:40, "Bernie Deitrick" <deitbe @ consumer dot org wrote:
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!

I would love to copy the formula from above, the problem is I can't
access it, I can't get into formulas, everything is greyed out and it
says formulas are not used in ledgers.

On 14 Nov, 20:24, "Bernie Deitrick" <deitbe @ consumer dot org wrote:
Gary,

What version of Excel are you using? *And, is the sheet protected?

Bernie

"Gary Huston" wrote in message

...
On 14 Nov, 18:40, "Bernie Deitrick" <deitbe @ consumer dot org wrote:



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!

I would love to copy the formula from above, the problem is I can't
access it, I can't get into formulas, everything is greyed out and it
says formulas are not used in ledgers.

I'm using office 2008 for Mac, the sheet is not protected.
I have asked in the Mac users forum but no replies.

Gary,

I'm not familiar with Office 2008, so I think that my help will end here,
with one last question - did you download the file from somewhere or create
it yourself?

Bernie



"Gary Huston" wrote in message
...
On 14 Nov, 20:24, "Bernie Deitrick" <deitbe @ consumer dot org wrote:
Gary,

What version of Excel are you using? And, is the sheet protected?

Bernie

"Gary Huston" wrote in message

...
On 14 Nov, 18:40, "Bernie Deitrick" <deitbe @ consumer dot org wrote:



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!

I would love to copy the formula from above, the problem is I can't
access it, I can't get into formulas, everything is greyed out and it
says formulas are not used in ledgers.

I'm using office 2008 for Mac, the sheet is not protected.
I have asked in the Mac users forum but no replies.