Tuesday, February 26, 2008

How do I revert back to the old pivot table layout?


If you open your Excel 2007 in order to create a Pivot Table, you will no doubt be faced with the new layout (pictured above).

If you feel more comfortable using Excel's familiar pivot table layout, you can alter your settings to show the older style pivot table drag and drop box (pictured below).



To enable the previous version's look, select Pivot Table Tools> Pivot Table Options > Options. When the options box opens, click on the Display tab. Place a check into the box next to Classic Pivot Table Layout.

Now you have all the new functionality with an old faithful look and feel.

14 Comments:

Ruaf said...

Is there any way to have the classic view as the default when creating a pivot?

Anonymous said...

I have not found a way. I heard they specifically left out a way to default to the classic menus and tools. That was very very bad customer service on the part of MS.

Christie Lewis said...

Thanks for your question, Ruaf and thank you to anonymous for your input.

At this time, I too have been unable to find a way to change the permanent default to maintain the classic pivot layout.

It does seem to stay on for addition pivots within the one workbook, but as soon as a new workbook is opened, you will need to alter your options for Classic View once again.

If I manage to stumble accross a work around for this issue, I'll be sure to post it.

Anonymous said...

You can kind of do it with a macro, but there are some limitations (i.e. have to run it in each new workbook).

If I come up with a better way I'll post in full.

Anonymous said...

Hello,
The only way you can revert to default classic pivot is this way:
Set the default save to excel 2003 so this time all your pivot tables will be classic.
You can do this in Start Office button - Excel Options -> save -> save files in this format -> excel 2003.
Hope it helps.

Anonymous said...

Hello,
The only way you can revert to default classic pivot is this way:
Set the default save to excel 2003 so this time all your pivot tables will be classic.
You can do this in Start Office button - Excel Options -> save -> save files in this format -> excel 2003.
Hope it helps.

Unknown said...

I will have the same issue as a lot of the stuff I do already has the classic view for pivot tables. However, I don't want to lose all the new functionality by saving everything in the 2003 formt. The workaround is this. Put something on one worksheet so that you can create a pivot table. Generate a pivot table & then change the pivot table to classic view. Set up your other preferences such as paper orientation to landscape, margins, font, etc. You can also store your macros on this workbook. Save it as a template and put it C:\Program Files\Microsoft Office\Office11\XLStart folder.

Everytime you now open Excel, this file will open up. You can overwrite the raw data on the one worksheet, save it & then go to the other worksheet where you had a pivot table saved in the classic view & refresh it. The other option is of course to do like everyone else is doing & that is generating a pivot table & then going to the Pivot Table Tools>Options>Display & check Classic Pivot Table Layout.

I think it stinks that we have to do this.

Unknown said...

If you keep doing it the old fashioned way, you'll never learn the new way. And in 2010, the old way is not an option.

Unknown said...

NopaleaPerfect, thanks Christie as a novice to pivot tables i find the older version a little easier to manipulate.
www.charisbusiness.com

Anonymous said...

I need the classic pivot table for the large files I pivot on. The new pivot option does not give me the functionality I need. To MS: Earth does not like the new pivot look!

SACHIN said...

THANKING YOU SO MUCH FOR UPDATING ALTER DETAILS

Anonymous said...

PivotGrid layout setting in .NET

Anonymous said...

You have to use VBA Code to accomplish this in more recent versions of Excel. The VBA code listed on the following forum works great for all sheets and applies to Excel 2010 & 2013 as well:

http://www.mrexcel.com/forum/excel-questions/357712-classic-pivot-table-view-i-excel-2007-a.html

Anonymous said...

customizing pivot grid table layout