+ Reply to Thread
Results 1 to 5 of 5

Open Pivot table Wizard shortcut commands ALT+D+P not working

  1. #1
    Registered User
    Join Date
    12-16-2015
    Location
    Barcelona
    MS-Off Ver
    MAC 2011
    Posts
    3

    Question Open Pivot table Wizard shortcut commands ALT+D+P not working

    On my MAC command+ALT+P opens the pivot table wizard with no problems . In this wizard I can select to select multiple consolidation ranges.
    However when I try to open this wizard on the Windows 2013 excel version at work when using the shortcuts I found for windows ( ALT+D+P), this does not work. I have added the Pivot table icon in the toolbar but this does not give me the same wizard as I got when using the shortcut command on my MA. The problem is I really need this wizard where I can select multiple consolidation ranges. The computer at work has Spanish excel version 2013. I really want to open this wizard in he windows excel does anyone know how to to this ?

    Thanks in advance !

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Open Pivot table Wizard shortcut commands ALT+D+P not working

    The keyboard shortcut is not
    ALT+D+P

    It's
    ALT+D, P

    Key in ALT+D
    release them
    Then key in P

    That will launch the wizard
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  3. #3
    Registered User
    Join Date
    12-16-2015
    Location
    Barcelona
    MS-Off Ver
    MAC 2011
    Posts
    3

    Re: Open Pivot table Wizard shortcut commands ALT+D+P not working

    Thank you for your reply! However when keying in these commands ALT+D and then P the function to split a group opens, still no pivot table wizard.
    I really don't know what the problem is.

  4. #4
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Open Pivot table Wizard shortcut commands ALT+D+P not working

    Did you add 'pivot table and pivot chart wizard' command to Qat? That is same wizard as before.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  5. #5
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,633

    Re: Open Pivot table Wizard shortcut commands ALT+D+P not working

    You shall have access to Quick Access Toolbar (QAT) via File->Options->QAT Then Once you use the creattor you shall see "oldschool 3-step version" which allows consolidation. See 2 screenshots (from Windows but shall be similar on Mac)
    Attached Images Attached Images
    Best Regards,

    Kaper

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. OPEN.DIALOG and GetOpenFilename commands not working
    By riwiseuse in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-20-2015, 12:31 PM
  2. Pivot table wizard not completing
    By Fizban in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-02-2014, 05:20 AM
  3. Replies: 2
    Last Post: 04-16-2012, 05:06 PM
  4. Replies: 0
    Last Post: 07-23-2011, 04:35 PM
  5. Replies: 5
    Last Post: 07-01-2011, 01:36 AM
  6. Excel 2007 : Pivot Table Wizard
    By scokaw in forum Excel General
    Replies: 5
    Last Post: 11-01-2010, 03:39 PM
  7. Excel 2007 : Pivot Table Wizard
    By mattyj in forum Excel General
    Replies: 1
    Last Post: 07-15-2010, 12:41 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1