disable 'GetPivotTable' in Excel for Mac

Question

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.

Answer 1

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.

Answer 2

AFAIK, 'Use GetPivotData' option isn't available on Excel for mac.

Answer 3

Shane is correct. GetPivotTable is always on in Excel on the Mac.

If you could turn it off, this code would run successfully:

Sub TurnGetPivotDataOff()

    Application.GenerateGetPivotData = False

    Application.GenerateTableRefs = xlGenerateTableRefStruct

End Sub

However, you are not allowed to change the setting to False on a Mac, so this code will not run.

This is just one of the many features left out of Excel on the Mac. You can add your feature request to the suggestion box or vote for this feature request if it has already been added to the list here:

http://excel.uservoice.com/forums/304933-excel-for-mac

Answer 4

Then you don't have Excel 2016 for Mac.

Answer 5

Please note that the date of the old answers. Those answers apply to the version of Excel 2016 that existed last August. The answer I made back then does not apply to current update versions of Excel. The feature set has changed considerably. 

Your answer applies to Excel version 15.21, which is the current edition. Your answer is correct today but is wrong for the question that was asked when it was asked.