ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   pivot table default settings (https://www.excelbanter.com/setting-up-configuration-excel/182011-pivot-table-default-settings.html)

stigarne

pivot table default settings
 
I wish to change the default of the fields settings of subtotals from
"automatic" to "none". I can do this manually but it is getting to be
tedious, a simple macro wont do the trick since this presumes that you know
the field name beforehand which seldom is the case. I use Excel 2007.

How can I change this default?


All times are GMT +1. The time now is 09:01 PM.

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