I've recently been 'forced' to use Excel in Office 2010. For various reasons I don't like the look and functionality of the new pivot tables - I prefer the 2007 version. Yes, I know, I know, call me a Luddite.
I have worked out that I can modify the way pivot tables look and feel by right clicking on the body of a new pivot table and setting the 'Classic' Pivot Table Layout and clicking a few buttons in the Display tab.
The problem is I have to do this every time I set up a new pivot table - several times a day - and it gets a bit tedious.
I thought I could get round it by simply recording a macro and assigning it to a button on my Quick Access Toolbar so that it performs the same actions each time.
This doesn't work because the VBA commands stored behing the Macro seem to record the pivot table number and therefore the macro falls over when used on a new pivot table with a different number.
I'm wondering if it is possible to modify the VBA to make it generic rather than specific to a particular pivot table? I have no VBA skills at all so any solution needs to be really Mickey Mouse.
Or maybe there's another way to achieve the same end result without using a macro?
Cheers
I have worked out that I can modify the way pivot tables look and feel by right clicking on the body of a new pivot table and setting the 'Classic' Pivot Table Layout and clicking a few buttons in the Display tab.
The problem is I have to do this every time I set up a new pivot table - several times a day - and it gets a bit tedious.
I thought I could get round it by simply recording a macro and assigning it to a button on my Quick Access Toolbar so that it performs the same actions each time.
This doesn't work because the VBA commands stored behing the Macro seem to record the pivot table number and therefore the macro falls over when used on a new pivot table with a different number.
I'm wondering if it is possible to modify the VBA to make it generic rather than specific to a particular pivot table? I have no VBA skills at all so any solution needs to be really Mickey Mouse.
Or maybe there's another way to achieve the same end result without using a macro?
Cheers
Last edited: