Go Back   MacRumors Forums > Apple Systems and Services > Mac Basics and Help

Reply
 
Thread Tools Search this Thread Display Modes
Old Jan 26, 2013, 04:24 PM   #1
lostnhre
macrumors newbie
 
Join Date: Jan 2013
Clear Pivot Function in Excel Mac

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
lostnhre is offline   0 Reply With Quote
Old Jan 26, 2013, 07:02 PM   #2
RedCroissant
macrumors 68000
 
RedCroissant's Avatar
 
Join Date: Aug 2011
Location: California
Quote:
Originally Posted by lostnhre View Post
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.
__________________
Welcome to the Grid, Program.

27" iMac, 3.2GHz i5, 16GB RAM, 3TB HDD; 32GB iPad 1 WiFi+3G; 30GB iPod Video 5G
RedCroissant is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Systems and Services > Mac Basics and Help

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Visual Basic Module/Macro works in Windows Excel but not Mac Excel 2011 chrispy1042 Mac Applications and Mac App Store 2 May 4, 2014 08:41 AM
Templates for Microsoft Excel - Best Excel Spreadsheets for Mac! Alexander-James Mac Applications and Mac App Store 1 Apr 24, 2014 02:19 AM
Formulas in Excel on Mac... Switch to values in Excel on PC Noob2mac Mac Applications and Mac App Store 2 Apr 24, 2013 06:24 AM
Excel / Google Spreadsheets function to live-update number of Twitter followers? jent Mac Applications and Mac App Store 1 Nov 20, 2012 04:19 PM
Pivot Display compatible with Mac goldfronts1 Mac Peripherals 3 Oct 6, 2012 12:12 AM

Forum Jump

All times are GMT -5. The time now is 03:25 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC