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