Hi
I have created a pivot table and attached a pivot chart then added 2 slicers, all works well, but my boss uses Excel for AppleMac, the Pivot table works fine on his report but the slicers do not work. is there a way around this?
Thanks
Paul
As I read it, slicers on Mac can work on the new Office version there. So maybe the boss uses the older (2011) version? And it seems that on the Mac the slicers doesn't work on a Chart, only on the tables!
What I've heard is that charts linked to pivot table data now act as pivot charts on the Mac, without having the various pivot-related buttons on them.
What I think is that anyone who is serious about using Excel should use a Windows computer, or at least use Parallels or Bootcamp and run the Windows version of Office on their Mac. There are just too many differences between the Mac and Windows versions of Office, and too many constraints to using Office on the Mac.