Calc

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DStore - 21 Sep 2007 15:44 GMT

I have a cell reference in a cell to a seperate sheet (e.g. =sheet2!c2) which
contains a simple addition formula (g1+g2+g3). The problem is that the
totals are not automatically updating in the cell reference cell when there
are changes in the sum sheet (g1_g2+g3+g4). I have to manually go in to the
cell reference, then the totals will update. F9 doesn't update the sum--I
still have to go into the cell to updated the total. I checked the calc
settings which are automatic.

Reply to this Message

Teethless mama - 21 Sep 2007 17:26 GMT

Tools > Options > Calculation tab > select Automatic > OK

> I have a cell reference in a cell to a seperate sheet (e.g. =sheet2!c2) which
> contains a simple addition formula (g1+g2+g3). The problem is that the
[quoted text clipped - 3 lines]
> still have to go into the cell to updated the total. I checked the calc
> settings which are automatic.

Reply to this Message

DStore - 21 Sep 2007 18:22 GMT

I have calc set to Automatic (in both sheets) as I referenced in my original
post.

> Tools > Options > Calculation tab > select Automatic > OK
>
[quoted text clipped - 5 lines]
> > still have to go into the cell to updated the total. I checked the calc
> > settings which are automatic.

Reply to this Message