You can't change the default for that pivot table option. You can
manually change it for each pivot table, or create a macro that changes
the pivot table options.
Dan wrote:
I want to know how can I set the default for the classic Pivottable layout in
version 2007. I've tried the pivottable options display tab and checked
the Classic Pivottable layout, didn't work. ~thank you
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html