Pivot Table Wizard "Layout" button disabled (greyed out)

C

cdelarte

I am trying to use the Pivot Table wizard in Excel 2007 (using "alt-d,
p" to launch it), however in step 3 of 3, the Layout button is ALWAYS
disabled (greyed out) regardless of how I set the preceding options.
Any suggestions on how to enable this?
 
H

Herbert Seidenberg

Click Finish and and an Excel 2007 layout window will appear.
Also reupload my response to your last post for automation options.
 
S

ShaneDevenshire

Hi,

Bad news! - this feature is disabled for regular pivot tables in 2007. If
you are creating pivot tables from certain kinds of external data sets you
will have the ability to use Layout, but not with regular Excel based data.

Further more I'm not sure you want to be in there anyway, it tends to crash
Excel when you try dragging fields into the various areas.


If this helps, please click the Yes button.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Menu Item Options -> Formulas Disabled for Pivot tables. 2
Delete Pivot Table Calculated Field 2
Pivot Tables in Excel 2007 vs 2003 1
Grand Substraction instead of Grand Total in pivot table 3
Get Data button in Pivot Table Wizard 10
Pivot Tables 1
How to base a pivot table on another pivot table? 3
Pivot Table Wizard in Excel 2007 6

Top