thank you,
I've been changing it manually I thought it would be a hidden default.
thank you for your help


"Debra Dalgleish" wrote:

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