F9 Key for totals
 

Why would you need to press the F9 key in order to total a subtotal after
entering a new value into a cell?

F9 Key for totals
 

Because you have automatic calculation turned off.

To turn it on, go to Tools--Options-_Calculation and check automatic
calculation.

Dave
--
Brevity is the soul of wit.


"Transfer from onyx to access database" wrote:

Why would you need to press the F9 key in order to total a subtotal after
entering a new value into a cell?

F9 Key for totals
 

So it this in the spreadsheet when it is open or just opeing Excel? BTW,
sorry I don't know why or how it linked this question with my header for
access...

"Dave F" wrote:

Because you have automatic calculation turned off.

To turn it on, go to Tools--Options-_Calculation and check automatic
calculation.

Dave
--
Brevity is the soul of wit.


"Transfer from onyx to access database" wrote:

Why would you need to press the F9 key in order to total a subtotal after
entering a new value into a cell?

F9 Key for totals
 

Thank you, that was the issue.

"Dave F" wrote:

Because you have automatic calculation turned off.

To turn it on, go to Tools--Options-_Calculation and check automatic
calculation.

Dave
--
Brevity is the soul of wit.


"Transfer from onyx to access database" wrote:

Why would you need to press the F9 key in order to total a subtotal after
entering a new value into a cell?