Power query slicers on mac

adamelston

New Member
Joined
Jul 22, 2016
Messages
31
Hello, I've opened an excel dashboard I've put together on mac and discovered that the pivot slicers don't work - it is fine in Windows. Is there a setting that will allow the slicers to work?
Many thanks,
A

PS - when attempting to filter the actual pivot tables I receive "The pivot table connects to an external data source that's not supported in this version of Excel." Does anyone know if there's a way round this, or is that it?!
 
Last edited by a moderator:

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Watch MrExcel Video

Forum statistics

Threads
1,119,185
Messages
5,576,582
Members
412,735
Latest member
jwoods1204
Top