Join Dennis Taylor for an in-depth discussion in this video, Watching VBA code being created, part of Excel for Mac 2016: Macros. So will be any pivot table, that was created via the 'Import from Microsoft Access Database' option as Excel for MAC does not support OLEDB connections, either. Consequently, any pivot table having source data based on the Excel Data Model will be unfilterable if the spreadsheet is opened by a MAC user.
1.Excel for MAC does not support PowerPivot.
