This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
hi there. i am using Office 2016 for Mac and i would like to disable this 'GetPivotTable' function in Excel. on my PC, i can do that easily from 'Formulas -> Working with formulas -> uncheck the 'Use GetPivotData' functions for PivotTable references, but i cannot find this option on my Mac. please help. thanks.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
You really had me going, and I was so mad at Microsoft for a minute, but you're completely damn wrong. It's the simplest thing in the world to deactivate: Go to PivotTable Analyze -> Options (click the triangle dropdown button) -> Uncheck "Generate GetPivot Data." Screenshot below.
This is good but there's a potentially useful addition for people with multiple pivot tables.
If you customise your quick launch toolbar you can add the pivot table option as a quick launch item. This is marginally useful as it saves one click on filmstrip selection but more useful as it seems to apply a global choice to the spreadsheet. I've only done very limited testing.
I noticed something unusual when the drop down was available even when no pivot table was selected.