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 !
Bookmarks