Clear Pivot Function in Excel Mac

[lostnhre]

HI
I have migrated from Windows to MAC and I have a Macro in Excel that uses the Clear Pivot function on the windows side but I can not find an equivalent on Excel in Mac on 2011 or 2008. I'm reaching out to see if anyone found it. Most people I ask are shocked that it doesn't exist but I can not find anything on this.
thanks in advance

[RedCroissant]

Originally Posted by lostnhre

HI
I have migrated from Windows to MAC and I have a Macro in Excel that uses the Clear Pivot function on the windows side but I can not find an equivalent on Excel in Mac on 2011 or 2008. I'm reaching out to see if anyone found it. Most people I ask are shocked that it doesn't exist but I can not find anything on this.
thanks in advance

I think LibreOffice uses the clear pivot function(from what I remember). It's also free and I recommend the app anyway because I use that for all my "standard" work and to check the quality of my exports from iWork.