A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

classic pivottable layout



 
 
Thread Tools Display Modes
  #1  
Old April 4th, 2008, 07:07 AM posted to microsoft.public.excel.newusers
dan
external usenet poster
 
Posts: 1,408
Default classic pivottable layout

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
  #2  
Old April 4th, 2008, 03:28 PM posted to microsoft.public.excel.newusers
Bob Umlas, Excel MVP
external usenet poster
 
Posts: 275
Default classic pivottable layout

On the Options tab pf the PivotTable Tools, the leftmost group, PivotTable,
click Options, then click Options. In that dialog, click the "Display" tab,
and use the 4th checkbox, "Classic Picottable layout"
Bob Umlas
Excel MVP

"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

  #3  
Old April 5th, 2008, 05:29 AM posted to microsoft.public.excel.newusers
Debra Dalgleish
external usenet poster
 
Posts: 1,998
Default classic pivottable layout

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

  #4  
Old April 6th, 2008, 07:40 AM posted to microsoft.public.excel.newusers
dan
external usenet poster
 
Posts: 1,408
Default classic pivottable layout

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


  #5  
Old April 6th, 2008, 07:47 AM posted to microsoft.public.excel.newusers
dan
external usenet poster
 
Posts: 1,408
Default classic pivottable layout

I already tried that method, it works only for the current PivotTable next
time I create a new one I have to manually change it again. perhaps it's the
only way to set it up.
thank you

"Bob Umlas, Excel MVP" wrote:

On the Options tab pf the PivotTable Tools, the leftmost group, PivotTable,
click Options, then click Options. In that dialog, click the "Display" tab,
and use the 4th checkbox, "Classic Picottable layout"
Bob Umlas
Excel MVP

"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

  #6  
Old April 1st, 2010, 04:30 PM posted to microsoft.public.excel.newusers
CherylLynn
external usenet poster
 
Posts: 3
Default classic pivottable layout

How do we convince Microsoft to make it possible to change the default to
Classic? Many users prefer it, at least in my office. Can be a PITA to have
to set it for each individual pivot table or to run a macro every time.

Microsoft... if you're lurking out there, please consider this!

"Dan" wrote:

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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:56 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.