Apologies if this has been previously asked/answered. I could not find reference to it.
I've recently upgraded from Excel 2003 to 2010. Now the default pivot table layout is... different. I can't get comfortable with it and always revert to the 'classic pivotable layout' by manually changing the display options in the PivotTable Options window. This is a pain everytime I create a pivot table.
Is there a way to save my 'classic layout' preference so that future sessions of Excel and pivot tables default to the 'classic layout'? If Microsoft didnt build in an easy setting, perhaps there is VBA code that I can save and use for future Excel sessions - if that's the case then can you share the VBA code and process for implementing it on my PC?
Thanks for your consideration. BRIANH
I've recently upgraded from Excel 2003 to 2010. Now the default pivot table layout is... different. I can't get comfortable with it and always revert to the 'classic pivotable layout' by manually changing the display options in the PivotTable Options window. This is a pain everytime I create a pivot table.
Is there a way to save my 'classic layout' preference so that future sessions of Excel and pivot tables default to the 'classic layout'? If Microsoft didnt build in an easy setting, perhaps there is VBA code that I can save and use for future Excel sessions - if that's the case then can you share the VBA code and process for implementing it on my PC?
Thanks for your consideration. BRIANH