LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 6th 09, 06:11 PM posted to microsoft.public.excel.setup
external usenet poster
First recorded activity by ExcelBanter: Sep 2006
Posts: 35
Default 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!!!

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Range setting for pivot table aw Excel Discussion (Misc queries) 1 May 25th 09 12:37 PM
setting up a pivot table via macro? SteveM Excel Discussion (Misc queries) 0 November 5th 08 11:01 PM
pivot table format report - setting default stevep Excel Discussion (Misc queries) 0 December 14th 05 03:26 PM
Setting Range in Pivot Table Dhiraj Charts and Charting in Excel 1 August 15th 05 01:27 AM
Setting default pivot table field setting to "sum" Mr. Moose Excel Discussion (Misc queries) 2 December 21st 04 04:43 PM

All times are GMT +1. The time now is 07:38 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017