Excel Mac Pivot Table Assistant

keshia21 Posted messages 203 Registration date Status Member Last intervention -
Raymond PENTIER Posted messages 58213 Registration date Status Contributor Last intervention - 5 Oct 2018 at 19:27

Hello,
I am looking for the function "Pivot Table Assistant on Mac".
I can't find this function in the function ribbon. And the shortcut alt+cmd+P isn't working.
I would like to create a Pivot Table with data from several tabs.
I am using MAC OSX SIERRA and Excel 2018.
Thank you for your help.
Have a good evening.

Configuration: Macintosh / Safari 11.1.1

2 answers

Answer 1 / 2
Raymond PENTIER Posted messages 58213 Registration date Status Contributor Last intervention 17 482

Hello.

This TCD assistant does not exist by default. It needs to be installed ...
https://forums.commentcamarche.net/forum/affich-4877222-annuler-l-assistant-d-un-tableau-croise-dynam#3
--
Retirement is great! Especially in the Caribbean...
Raymond (INSA, AFPA)
1
1. keshia21 Posted messages 203 Registration date Status Member Last intervention 6
  
  Good evening Raymond,
  Thank you for taking the time to read and reply to me.
  You recommend that I install the TCD assistant, but I can't find it in the ribbon like on Excel for Windows. And the link you gave me doesn't explain where to find it and how to install it. HELP
  Thank you in advance for your help.
  Have a good evening.
  
  0
Answer 2 / 2
eriiic Posted messages 24581 Registration date Status Contributor Last intervention 7 281

Hello,

on Windows:
Customize the ribbon, in the drop-down list choose 'Show All Commands'
It will then appear in the list.
eric

--
By continuously trying, we eventually succeed.
So the more it fails, the more chances we have that it works. (the Shadoks)
In addition to thanking (yes, really, it happens!!!), remember to mark it as resolved. Thank you
1
1. keshia21 Posted messages 203 Registration date Status Member Last intervention 6
  
  Good evening Eric,
  Thank you for taking the time to read and respond to me.
  You advise me to install the Pivot Table Assistant like in Excel for Windows. But I am not using Windows; I use Excel for Mac and I cannot find it in the ribbon.
  Thank you in advance for your help.
  Have a great day.
  
  0
2. eriiic Posted messages 24581 Registration date Status Contributor Last intervention 7 281
  
  It's not about installing it, it's already there, at least on Windows.
  It's about adding access to the tool that is missing from the ribbon.
  I'm giving you the steps for Windows, you should take inspiration from that for Mac (or just give me one). eric
  
  0
3. keshia21 Posted messages 203 Registration date Status Member Last intervention 6
  
  Good evening Eric,
  Actually, I have been able to install it on my Windows computer without any problem for a long time, but I can't find it in the ribbon on my Mac like I do on my Windows computer.
  Someone just told me that it doesn't exist on the Excel version for Mac.
  What a shame
  Thank you anyway for your patience
  Have a good evening
  
  0
4. eriiic Posted messages 24581 Registration date Status Contributor Last intervention 7 281
  
  Oh really? Which version?
  https://support.office.com/en-us/article/consolidating-data-from-multiple-sources-into-a-pivot-table-8f476919-40b3-4133-9870-26f4d9f21ad6
  
  0
5. keshia21
  
  Good evening Eric,
  Thank you for your response.
  I had read the article from the link you posted, but nothing works.
  When I press cmd+alt+p, nothing happens.
  Mac OS X High Sierra 2013
  Thank you and have a good evening.
  
  0

Excel Mac Pivot Table Assistant

2 answers

Unable to open xsl and xslx files

Pixma ts printer is broken

The black swift flies for 10 months in a row without interruption

No internet connection possible

Print a page in the right orientation under windows 11

Change a contact’s ringtone

Samsung wallet

View facebook on my tv

Unusable screen

Printer port error on canon ts3100 printer