Thanks heaps Gord ... it worked.

"Gord Dibben" wrote:

Tim

See answer to previous post.


Gord Dibben Excel MVP

On Thu, 3 Mar 2005 21:05:05 -0800, Tim Mc <Tim
wrote:

The total amount only recalculates when I filter, click in the cell formula
(=SUBTOTAL(9,O5:O1000)and press enter.

It doesn't recalculate on it's own.

This is also happening to spreadsheets where the subtotal worked fine in the
past.