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

  • Thread starter Thread starter cdelarte
  • Start date Start date
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?
 
Click Finish and and an Excel 2007 layout window will appear.
Also reupload my response to your last post for automation options.
 
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.
 
Back
Top