ExcelBanter

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

Jesse

Default Pivot Table Setting
 
Just switched to Excel 2007 a week ago. I'm loving it. However, every time I
creat a pivot table, the table pops up in the "new" format. I like to drag
and drop so I have to right click in the pivot and choose Options, Display
and then click the box labeled "Classic Pivot Layout"

Can I not make this the default so I don't have to do this every time? I do
a lot of data mining and this is getting on my nerves!!!


All times are GMT +1. The time now is 09:23 AM.

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