ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Autosum button performing subtotal (https://www.excelbanter.com/excel-discussion-misc-queries/117095-autosum-button-performing-subtotal.html)

rfIPS

Autosum button performing subtotal
 
For some reason, when one of my users hits the Autosum button, it performs a
subtotal instead. Does anyone know how to fix this?

thx!

Dave Peterson

Autosum button performing subtotal
 
I'm betting that your friend's data has data|filter|autofilter applied and is
filtering that range.

That autosum button is pretty darn smart!

rfIPS wrote:

For some reason, when one of my users hits the Autosum button, it performs a
subtotal instead. Does anyone know how to fix this?

thx!


--

Dave Peterson


All times are GMT +1. The time now is 07:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com