SUBTOTAL function not responding

Hello guys,

I am using the SUBTOTAL function in the attached sheet but its not responding as it used to respond earlier.

Like, if you select any value from the drop down menu on the header, it always returns the same value rather than returning the value based on the visible cells only.

I have tried on other sheets as well but the response is same. Maybe some setting has been changed as it used to work fine earlier. Please help me.

Thanks

I think it's in your Excel Settings... When opening your workbook and checking the SUBTOTAL values, everything's working fine here.

If you press F9 key does the value update? If so you may have calculate set to "Manual". Try

Tools > Options > Calculation > set to "automatic"

Originally Posted by daddylonglegs

If you press F9 key does the value update? If so you may have calculate set to "Manual". Try

Tools > Options > Calculation > set to "automatic"

Thanks dear... it was set to "Manual"... its working absolutely fine now... Thanks once again

@ sweep: In my Excel 2007 it doesn't include the hidden cells when using

=SUBTOTAL(9,D6:D16)

Is it a version-related issue?

=SUBTOTAL(9,D6:D16)

should be fine, it won't sum rows that are hidden by filtering. If you change to 109 that still excludes rows hidden by filtering...but also excludes rows hidden with Hide (unlike the previous version)

Totally clear! That's my learning for today, time for a beer ;-)