Forum

Notifications
Clear all

Slicers not working on Excel for AppleMac

3 Posts
3 Users
0 Reactions
126 Views
(@benjamip)
Posts: 89
Estimable Member
Topic starter
 

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

 
Posted : 12/11/2017 9:32 am
(@fravis)
Posts: 337
Reputable Member
 

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!

 
Posted : 12/11/2017 11:16 am
(@jonpeltier)
Posts: 9
Active Member
 

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.

 
Posted : 18/11/2017 9:57 am
Share: