Hi guys
I am working with excel 2007 and was just wondering if anyone has some code which turns the pivot table layout into the "Classic PivotTable layout"
Basically some code which mimics the following
Right click on the pivot table
click PivotTable options...
click Display
check "Classic...