Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

lostnhre

macrumors newbie
Original poster
Jan 26, 2013
1
0
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

Suspended
Aug 13, 2011
2,268
96
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.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.